Order alphabetically... how??

[jpr]

Hi, I know it is possible, but how could I use the ORDER BY string in my mysql query to sort the data alpabetically?

Thank you
Jason

[Lars_Berg]

select * from ogrish order by aleb

change table and columnname as apropriate.

[jburfield]

ORDER BY field_name;

You can add asc, or desc to make it sort up or down.

Something like:

SELECT firstname, lastname from TABLE order by lastname asc;

-- Jason

[eoghain]

SELECT fname, lname
  FROM people
 ORDER BY lname;

That will give you something close to an alphabetical listing. The ORDER BY clause sorts like a computer so if you are sorting numbers stored as text, or mixed case items it might look wierd some times.

Numbers 1-10 sorted by ORDER BY:
1
10
2
3
4
5
6
7
8
9

Or something like that.