except queries

[defiance]

Hi.

can any1 of you help me out?

i need to run this queries;

select keyword, id from table where keyword like %keyword%, but i need to exclude some id.

lets say i need to exculde id=3
the queries would be

select keyword, id from table where keyword like %keyword% exclude id = 3

please help me...

thank you so much!!!!

[Lats]

Maybe this...

SELECT
   keyword, id
FROM
   table
WHERE
   keyword
LIKE 
   '%keyword%'
AND
   id != 3

[gesf]

  SELECT keyword, id 
     FROM table 
        WHERE keyword LIKE '%whatever%' 
        AND id <> 3

[defiance]

oh yeah.....
that is cooll....


can i have mulitple exception?

like

and id != 3 and id !=4 and id !=5?

i believe there is another way to do it right/?

thankz!

[gesf]

   SELECT keyword, id 
      FROM table 
         WHERE keyword LIKE '%whatever%' 
         AND id <> 3
         OR id <> 4
         OR id <> 6

That should work

[Lats]

A bit neater...

SELECT
   keyword, id
FROM
   table
WHERE
   keyword
LIKE 
   '%keyword%'
AND
   id NOT IN(3,4,5)

[gesf]

I knew there was another and better way!
Great Lats

[defiance]

COooll stuff

thank you everyone.

[r937]

gesf, your query will return all rows in the table

be careful when mixing ANDs and NOTs and ORs