sidewinder
Reputation: 3163
MySQL - Ordering all data in alphabetical order but placing a particular item last
Assuming I have the following, data from a field:
Category Name
-------------
Games
Movies
All
Music
Software
I want to order the above data in alphabetical (ascending) order but I want 'All' to appear last at the bottom of the list. Not sure how to do this. Thanks.
Upvotes: 1
Views: 2074
Answers (2)
HBublitz
Reputation: 680
SELECT Category_Name, if(Category_Name='All',1,0) as orderAid
FROM CategoryTable
ODER BY orderAid, Category_Name
Upvotes: 1
Related Questions
- Sort MySQL results alphabetically, but with numbers last
- mysql SQL: specific item to be first and then to sort the rest of the items
- MYSQL Order By in a specific order
- MySQL order group of records by alphabetical order
- Specify value to appear last in ordered results
- Put a specific row first and then order by a column
- Alphabetical MYSQL Sort of Last Record In Group
- MySQL display results alphabetical order but show a particular item before the alphabetical sorted list
- ORDER BY FIELD , given field order comes at last
- MySQL - ordering alphabetically except for one entry?