mysql order by column name with space

Question

here's what I'm trying to do

SELECT id,`Full Name`,`Social Number` FROM data ORDER BY 'Full Name' ASC 

but it seems the order by Full Name ASC doesn't work. I think it's most probably because of the name which has space. any remedy to this problem?

Answer 1

Try enclosing them in back-ticks like

ORDER BY `Full Name` ASC

HTH

Answer 2

try ORDER BY 2 ASC 2 refers to the second selected column which is FULL NAME