RedHouse
08-04-2009, 03:09 AM
I have a table of categories which I want to list in alphabetical order. However there is always a category called 'Other' which I want to always be displayed last on the list? Is there any simple way of doing this with MYSQL. I currently have the statement
SELECT * FROM categories ORDER BY name ASC;
but this displays the category 'Other' half way down the list.
SELECT * FROM categories ORDER BY name ASC;
but this displays the category 'Other' half way down the list.