Specific order by MySQL statement

From: Date: Mon, 07 Nov 2005 11:47:32 +0000
Subject: Specific order by MySQL statement
Groups: php.db 
Request: Send a blank email to php-db+get-40613@lists.php.net to get a copy of this message
Hi I am trying to get results from a MySQL query in a specific order, just using ASC or DESC will not work. For Example I have a field that can contain 4 possible values: 'Current', 'Completed','Withdrawn' or 'Transferred', I would like to order the results specifically like: Current Completed Withdrawn Transferred Is there any way i can do this using MySQL? Any help will be much appreciated. Thanks, Ade

« previous php.db (#40613) next »