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.

Hello,

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 developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.