By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,919 Members | 1,600 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,919 IT Pros & Developers. It's quick & easy.

display records which does not match a pattern

P: 1
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
Jan 15 '15 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.