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 !

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

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

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