Domestic

Andrew attended Barnard Castle School, where he was contemporary with future teammate Rory Underwood and was captain of the school 1st XV in 1981. Whilst in the northeast, both Underwood and Andrew played their rugby at Middlesbrough RUFC. Andrew then attended St John's College, Cambridge, and played for Cambridge University in the Varsity Match.

He joined Nottingham for one season in 1985/86 and then joined Wasps FC where he was first choice fly-half throughout most of the eight seasons he spent with the north London club. At Wasps FC he won the English League in 1990, eventually leaving to join Newcastle Gosforth in 1995 as both a player and as director of rugby.^[3]

The club had just been bought out by Sir John Hall in the lead-up to the game turning professional; they became the Falcons of today. During his time in charge of Newcastle Falcons he is credited with discovering Jonny Wilkinson. In 1991 he joined the famous Stade Toulousain (France) for one season. He was an ever-present when Newcastle Falcons won the 1997-98 Premiership.^[4] His playing career was ended in 1999 after an injury in training.^[5]

International

Andrew was fly-half for England during the Will Carling era, making a winning debut in January 1985 against Romania at Twickenham. For the next 10 years he was England's regular fly-half earning 70 caps, including 2 as captain. He was briefly dropped in 1993 as England tried out Bath RFC's Stuart Barnes for the fly-half's position, but regained it after two matches. After England finished 4th in the 1995 Rugby World Cup, he saw out his contract at Wasps and moved to the Newcastle Falcons. He made his final appearance for England after an absence of almost two years when he was called off the bench as a try scoring replacement against Wales in March 1997. In total, he scored 396 international points, won the Grand Slam with England 3 times and held the English record for the most points scored in an international - 30, scored against Canada in 1994.

Critics of the England side blamed him for kicking the ball too much rather than passing - perhaps unfairly since England three times broke the Five Nations records for tries scored, and points scored, with Andrew as fly-half (in 1990 despite not even winning the tournament, and again in 1992 and 1995): however it was undeniable that England's game plan was based very much more around their forwards than their backs, with kicking for territory and competing to win line-outs and rucks in opposition territory being a major part of the tactic. England did, however, enjoy a great deal of success with him as their Number 10.

Inconsistent early in his career as a place-kicker for penalties and conversions, and often ceding that duty to fullbacks Webb and Hodgkinson (only to have to take some kicks anyway, when Webb also proved inconsistent early in his own career), Andrew improved that aspect of his game greatly, until by the end of his career he was among the best in the world at it, as well as being a reliable source of dropped-goals.

He played in 3 Rugby World Cup competitions; 1987 (making 2 appearances), 1991 and 1995. Curiously, just as Wilkinson had beaten Australia in the 2003 Rugby World Cup Final with a drop goal, the last time Australia lost in the same competition was in 1995. In that year, it was Andrew who nailed a drop goal on the stroke of full-time to beat the Wallabies 25–22. Four years before, it was another late drop-goal by Andrew, in the semi-final against Scotland, that took England to the final against Australia.

In 1989 he had the honour of captaining the British and Irish Lions against France in a rare "home" match for the Lions. The game formed part of the celebrations of the bi-centennial of the French Revolution.^[6] In the final match, against ANZAC, of the Lions' victorious '89 tour to Australia, Andrew came on at inside center as a substitute for the injured Brendan Mullen. Andrew also toured to New Zealand with the Lions in 1993, starting at flyhalf over his England rival Barnes. The Lions lost the test series to New Zealand 2–1.

Post playing

Andrew remained as director of rugby at Newcastle Falcons after the injury that ended his playing career until on 18 August 2006 he was appointed by the RFU to undertake the post of Director of Elite Rugby to oversee all aspects of representative rugby in England, from the regional academies to the full senior side.^[7][8]

On 6 January 2011, Andrew's role as director of elite rugby at the Rugby Football Union was scrapped in an overhaul of the organisation's structure. It was reported that Andrew was invited to apply for one of the new roles created by this process, that of operations director.^[9] At a press conference on 16 November 2011 Andrew's position was described as Director of Elite Rugby and he reportedly took several attempts to (inconclusively) describe his responsibilities.^[10] He resigned as the RFU's director of professional rugby in February 2016.^[2]

On 10 November 2017, Andrew was inducted into the World Rugby Hall of Fame at a ceremony held in the Hall's facility in Rugby.^[11]