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?
Missing comma. Look closely.
-- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]