Filtering data in Mysql

Question

I know WHERE, LIKE, IN filters in database. But how can I filter with "except" ? I want to select all data except a specificdata. Thanks in advance

Answer 1

with NOT IN, usage is like IN

SELECT * FROM USERS WHERE ID NOT IN (1,2,3,4,5)

Answer 2

you can use NOT IN

Answer 3

WHERE NOT LIKE

WHERE NOT IN

Answer 4

WHERE column <> 'something' or column not like 'something' or column not in('something')

Answer 5

Note that you can use another query for NOT IN like this:

SELECT id FROM customers WHERE id NOT IN (SELECT id FROM bad_customers)