[SOLVED] Order by

[cry of war]

Say i have a table full of words and i want to select the words that have their first letter as an "A" then after that it sorts the items alphabetically how would i go about doing that I understand the query in all like SELECT * FROM 'blah' WHERE ???(goes in here some where) ORDER BY ???

 

Thanks in advance

 

CoW

[GingerRobot]

Sorry? Im not sure what the problem is. By ordering your results by the field, you would get the the results beginning with an a first. The query, at is simplest, is just:

 

SELECT * FROM `yourtable` ORDER BY `thefield`

[cry of war]

SELECT * FROM `items` WHERE 'Prefix is equal to "A"' ORDER BY `thefield`

 

for example

"items"

dog

apple

cat

ant

dish

 

so the query would select

apple && ant then it would put it in this order:

ant

apple

[trq]

SELECT * FROM `items` WHERE `thefield` LIKE 'A%' ORDER BY `thefield`

[cry of war]

thank you so much again thorpe your a life saver.