You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-matchday.tplss_players ORDER BY 2' at line 1 : SELECT PlayerID as player, CONCAT(PlayerFirstName,' ',PlayerLastName) AS name FROM web52-matchday.tplss_players ORDER BY 2