Member Avatar for JeanPhilippe

Hi, i'm trying to get something to work. I want to do a query with multiples "if not" conditions in a mysql query.

This is working : SELECT * FROM table WHERE column!='value'

This is not working : SELECT * FROM table WHERE column!='value' OR column2!='value'

I've tried all kind of apostrophe and it still not working.

My question is : How can i make multiple "if not" conditions in my mysql query?

Thank you !

  • 3 Contributors
  • 3 Replies
  • 117 Views
  • 1 Week Discussion Span
  • Latest Post Latest Post by ifezuec
Member Avatar for JeanPhilippe

Ok i found the solution myself. I used "AND" instead of "OR" and its working.

Member Avatar for jkon

This is not “if not” , it is NOT AND NOT

Member Avatar for ifezuec

pls is this the correct syntax for insertion in Mysql 5.1.41.

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.