The left-back was a transfer target for Manchester United but elected to stay at St James’ Park