Member Avatar for lostmymom

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

  • 3 Contributors
  • 2 Replies
  • 126 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by rch1231
Member Avatar for Traevel

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

Member Avatar for rch1231

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.