sort on column type enum

#1

Hi all

I have a column of type enum('A', 'AP', 'CR', 'D', 'DL', 'H', 'HD',
'HH', 'R', 'S', 'PL'). i want to sort the result by 'DL', 'H','A',and
the rest .

Thanks in advance

#2

vjyanand (AT) gmail (DOT) com wrote:

Quote:

I have a column of type enum('A', 'AP', 'CR', 'D', 'DL', 'H', 'HD',
'HH', 'R', 'S', 'PL'). i want to sort the result by 'DL', 'H','A',and
the rest .

ORDER BY column='DL' DESC, column='H' DESC, column='A' DESC

HTH
Kai

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

sort on column type enum

comp.databases.mysql comp.databases.mysql

sort on column type enum - 09-26-2006 , 09:56 AM

Re: sort on column type enum - 09-27-2006 , 02:37 AM