> mysql> explain SELECT * FROM campaign_t WHERE datestamp < 20041105\g
Try surrounding the value with quotes, i.e.: explain SELECT * FROM campaign_t WHERE datestamp < '20041105' -- Eric Jain -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]