Trying to figure out a MySQL query regarding dates... I have a large number of dates of birth in a database, all in the format 00/00/0000 or 0/0/0000... i am searching for 00/00/0000 but need to search for ones that in the other format also... or find a way to updates them all to the 00/00/0000 standard... some entries in the database are like this: 1/1/2002 others are like this 01/01/2002 Any suggestions on a query that will cover both possibilities?