SQL multiple NOT LIKEs?

[Erik]

How can I exclude multiple fields from a recordset with mySQL?

After some googling, I found this working solution:

SELECT *
FROM customers
WHERE customerID NOT LIKE '19'
ORDER BY customerName ASC

But what if I want to rule out customers no 19, 7 and 10?

I have tried:

WHERE customerID NOT LIKE '19,7 ,10'

and a dozen different approaches to that. No good.


Help greatly appreciated.

Erik

[RobGT]

Use the IN keyword.

WHERE customerID NOT IN ('19,7 ,10')

HTH
Rob
[url]http://robgt.com/[/url]

[Erik]

RobGT skrev:

> Use the IN keyword.
>
> WHERE customerID NOT IN ('19,7 ,10')

Thanx a bunch for the speedy response!

Somehow I could not get this to work. It doesn't display any error
message, but it doesn't rule out all the actual customers either, only
the customer ID first in line.

Example:

WHERE customerID NOT IN ('5, 6, 7, 19, 20')

Only ID #5 disappears from the list, leaving the rest still standing.

What am I doing wrong?

Erik

[Erik]

OK, now it's working. I had to wrap every ID # in ''

The correct recordset:

SELECT *
FROM kunder
WHERE kundeID NOT IN ( '5', '6', '7', '19', '20 ' )

Thanx to RobGT for lightning fast troubleshooting :)

Erik

[RobGT]

Sorry about the incorrect syntax - glad you got it sorted!
Now, where's that coffee!

LOL
Rob
[url]http://robgt.com[/url]

[Michael Fesser]

.oO(Erik)

>OK, now it's working. I had to wrap every ID # in ''

Numeric values don't have to be quoted.

>The correct recordset:
>
>SELECT *
>FROM kunder
>WHERE kundeID NOT IN ( '5', '6', '7', '19', '20 ' )

....
WHERE kundeID NOT IN (5, 6, 7, 19, 20)

Micha

[Erik]

Michael Fesser skrev:

>
> Numeric values don't have to be quoted.

Even better! Thx a lot! :)

Erik

[dora babu M]

Try this Query it's give best result


select * from [Item Code] not like '1' and [Item Code] not like '2' and [item code] not like '3'


Dora Babu M
Exertion Tech. PVT,.LTD.
Chennai.