Order by clause is not working in mysql 5 however same working in mysql 4

[lokesh pattajoshi]

hi everbody i was using following code for sorting in mysql 4 it was working fine but it is not working in mysql 5 can any body please help me.

SELECT data "data value" FROM TABLE_NAME order BY "data value"


Regards,
Lokesh Kumar Pattajoshi

[Paul Sturrock]

What is "data value"? Is is a literal, or the contents of a field?

[lokesh pattajoshi]

hi thanks for your replay data value is alias name.

[Campbell Ritchie]

Are you sure you haven't missed out an AS?

[lokesh pattajoshi]

hi Campbell what is AS? now i got the problem if i am using alias name with white space(example "First Name")then it is not working but how to resolve it i don't know can you please help??