SELECT * FROM pet WHERE birth >= "1998-1-1";
Try: SELECT * FROM pet WHERE birth >= "1998-01-01";
You need 2 characters for the day and month fields.
___/
/
__/
/
____/
Ed Leafe
http://leafe.com/
http://opentech.leafe.com
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
