Mike
I have a query that selects a list of results, ordering them by the status field. However, I want to further sort that by the type of status, that is:
Undefined Ready for Review Top Priority Priority Completed
ORDER BY FIELD( columnname, 'Undefined', 'Ready for Review', ... ) PB Mike Morton wrote:
I am sure that this has been asked - but in searching through google and lists for about an hour - hopefully someone will indulge me a repeat question here. I have a query that selects a list of results, ordering them by the status field. However, I want to further sort that by the type of status, that is: Undefined Ready for Review Top Priority Priority Completed Etc... Every sort that I try, of course, sorts alphabetically. Is there a way to define how the sort function works in the order by? I know that I could do this in PHP after populating the results into an array, but that is (in my opinion) an unnecessary step that could be handled at the database query.... Thanks! Sample query: Select * from development order by status
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
