How can i select all except specific ids using mysql?

Question

I want to select all ids except specific which like 28, 29, 30, 40. I tried following query.

SELECT * FROM oc_product_to_category WHERE product_id !IN  (28, 29, 30, 40)

I searched about it and find this. but it expr IN (28, 29, 30, 40) does not working. Can any is this possible with sql function? I would like to appreciate.

Giorgos Betsos · Accepted Answer · 2016-02-09 14:54:57Z

4

Just use NOT IN:

SELECT * 
FROM oc_product_to_category 
WHERE product_id  NOT IN  (28, 29, 30, 40)

answered Feb 9, 2016 at 14:54

Giorgos Betsos

72.3k10 gold badges69 silver badges103 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How can i select all except specific ids using mysql?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related