HOw to search alphabetically?

[fairous]

Hi, I am currently trying to modify the search script to allow me searching alphabetically? How would I do it? I want to search a field call the_tile . HOw can do do that? Thanks a whole bunch

Fairous

[trooper]

SELECT * FROM WHEREEVER ORDER BY field_name
or to go the other way (reverse alphabetically)

SELECT * FROM WHEREEVER ORDER BY field_name
DESC