How could i re-write the WHERE clause in this query?

[laanes]

Hi, i've got a question in my head:

 

How could i improve the WHERE clause in this query? :

 

$query = "SELECT cat_name FROM " . $table . " WHERE cat_id != 300 AND cat_id != 200 AND cat_id != 100";

 

It works, but i can imagine when there will be more excluded categories, there will be a lot of AND's.

 

Any way to make this query more decent?

 

Kind regards,

laanes

[Maq]

You could use NOT IN.

[fenway]

But that's the most inefficient query you could possibly write.

[laanes]

You could use NOT IN.

So.. something like

$query = "SELECT * FROM " .$table. " WHERE 100, 200, 300 NOT IN " .$table. ".cat_id";

?

 

But that's the most inefficient query you could possibly write.

What would be a better way then?

 

 

[kickstart]

Hi

 

Not quite.

 

$query = "SELECT * FROM " .$table. " WHERE cat_id NOT IN (100, 200, 300)";

 

All the best

 

Keith

[laanes]

This works, thank you.