The above date is stored in varchar type i want to display the error date for rectification. so i tried NOT LIKE '//____' but it didnot work. I want to display the records which does not have the 02/02/2000 pattern. thanks

You could use MySQL's REGEXP to search for that pattern.


You can use not equal:

<> or !=
Match rows if the two values are not equal.

select * from mytable where mytable.fieldname <> '02/02/2000'
Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.18 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.