sandy1028 Posted October 7, 2009 Share Posted October 7, 2009 The field should contains values like dddd/dd/dd/strings. Some values have other characters like ',' and space in between. How to find the field with the value which doesnot contains the proper format of 4digits/2digits/2digits/strings Quote Link to comment https://forums.phpfreaks.com/topic/176812-query-to-find-exact-match/ Share on other sites More sharing options...
cags Posted October 7, 2009 Share Posted October 7, 2009 Surely all rows in your database should have the same format? Quote Link to comment https://forums.phpfreaks.com/topic/176812-query-to-find-exact-match/#findComment-932272 Share on other sites More sharing options...
suresh64633 Posted October 7, 2009 Share Posted October 7, 2009 Hi, Try this regular expression. SELECT '1234/56/78/sdf' REGEXP '[0-9]{4}/[0-9]{2}/[0-9]{2}/[a-z]'; Thanks Quote Link to comment https://forums.phpfreaks.com/topic/176812-query-to-find-exact-match/#findComment-932323 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.