on 09/14/2003 06:14 PM, Paul DuBois at [EMAIL PROTECTED] wrote: > ORDER BY IF(sort_order IS NULL,1,0), sort_order, added;
select title, sort_order from resources order by IF(sort_order IS NULL,1,0) sort_order ASC limit 5; ERROR 1064: You have an error in your SQL syntax near 'sort_order ASC limit 5' at line 1 Any ideas? -- ------------------------------------------------------------- Scott Haneda Tel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED] Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]