thank for all your help ORDER BY status = 'DEAD', '$sess_quotes_search_by' ...
was the correct modification paul ----- Original Message ----- From: "Svensson, B.A.T. (HKG)" <[EMAIL PROTECTED]> To: "Harald Fuchs" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Monday, May 13, 2002 3:24 PM Subject: RE: can mysql do this sql ? > > In article <010801c1fa77$d5828ec0$[EMAIL PROTECTED]>, > > [EMAIL PROTECTED] writes: > > > > what i would like to acheive is BEFORE doing the ORDER BY > > > i would like to sort the records into two blocks based on whether the field > > > status is DEAD . The records containing DEAD will occur in the bottom block. > > > Then further ordering will occur in these blocks.Can this be acheived using > > > 1 SQL query ? > > > > Yes: > > > > ... ORDER BY status = 'DEAD', '$sess_quotes_search_by' ... > > Shouldn't it be: > > ORDER BY status <> 'DEAD', ... > > if "DEAD" are to occur last? > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
