Jim, > Shouldn't it be: > SELECT * FROM orders WHERE order_date >= '2010-01-01' AND order_date <= > '2010-01-30' ORDER BY order_date; > > ? > > change the "=>" and repeat the column_name. Datetime should be datetime or > timestamp;
Spot on. Thank you for the clarification, obviously a syntax mistake on my part. -ML -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org