Is multiple "not like" possible?

[bayder]

Hi,

 

I am trying to create a query to filter out using \"not like\" now this is fine if I use a single \"not like\", but I always get an error when using a second or more.

 

for example

 

mysql_query(\"SELECT DISTINCT mystuff FROM table WHERE mystuff NOT LIKE \"%one%\" OR mystuff NOT LIKE \"%two%\"\");

 

which is strange because the \"like\" syntax works fine

 

eg.

mysql_query(\"SELECT DISTINCT mystuff FROM table WHERE mystuff LIKE \"%one%\" OR mystuff LIKE \"%two%\"\");

 

Can anyone enlighten me here please.

[Barand]

Do ()\'s help? eg

 

SELECT DISTINCT mystuff FROM table 

WHERE ((mystuff NOT LIKE "%one%") 

OR (mystuff NOT LIKE "%two%")) " 

[bayder]

Yes

 

SELECT DISTINCT mystuff FROM table

WHERE mystuff NOT LIKE (\"%one%\")

OR mystuff NOT LIKE (\"%two%\")\"

 

Thank you