Exclude 2 rows from select

Question

I know I can exclude a row like so:

SELECT * FROM products WHERE id <>1

But I need to exclude 2 products, I've tried:

SELECT * FROM products WHERE id <>(1,2)

But no luck.

[MYSQL OR vs IN](http://stackoverflow.com/questions/782915/mysql-or-vs-in-performance) — George, Jun 05 '15 at 12:18

score 3 · Accepted Answer · edited May 23 '17 at 12:03

3

Try this

SELECT * FROM products WHERE id  not in (1,2)

IN is definately faster than OR. See this MYSQL OR vs IN performance

edited May 23 '17 at 12:03

Community

answered Jun 05 '15 at 12:17

Manashvi Birla

score 0 · Answer 2 · answered Jun 05 '15 at 12:19

0

Use NOT:

SELECT * FROM `products` WHERE `id` NOT IN (1, 2);

Performance wise, IN is faster than comparison!

answered Jun 05 '15 at 12:19

@downvoter, can you let me know what the **** is the problem here? Hit and run downvoters should be hit and ran upon!!! – Praveen Kumar Purushothaman Jun 05 '15 at 12:39

2 Answers2