query to find exact match

[sandy1028]

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

[cags]

Surely all rows in your database should have the same format?

[suresh64633]

Hi,

  Try this regular expression.

 

SELECT '1234/56/78/sdf' REGEXP '[0-9]{4}/[0-9]{2}/[0-9]{2}/[a-z]';

 

Thanks