I store date in varchar type in a table. unfortunately some users didn't use the date picker and manually entered date erroneously. I want to display records which does not meet the mm/dd/yyyy format that is 10/10/2000. I tried the mysql
like '__/__/____' but it didnt work. what query to use please help