List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:September 28 2000 10:54pm
Subject:Re: SELECTive ordering
View as plain text  
In the last episode (Sep 28), Kent Wang said:
> I have a table of oddly sorted rows. When I SELECT, is there a way
> that one particular row called General is always selected first,
> followed by the rest of the selected rows?

try:

SELECT * FROM mytable ORDER BY IF(field1='General',1,0);

-- 
	Dan Nelson
	dnelson@stripped
Thread
SELECTive orderingKent Wang29 Sep
  • Re: SELECTive orderingDan Nelson29 Sep
  • Re: SELECTive orderingSusan Murray29 Sep
Re: SELECTive orderingKent Wang30 Sep
  • Re: SELECTive orderingDon Read30 Sep