Re: SELECTive ordering

[Dan Nelson]

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