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

ahmetunal · Accepted Answer · 2010-07-14 12:33:37Z

5

with NOT IN, usage is like IN

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

answered Jul 14, 2010 at 12:33

ahmetunal

3,9691 gold badge25 silver badges28 bronze badges

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

Comments

Stu Thompson · Accepted Answer · 2011-05-09 11:44:10Z

2

Three approaches:

WHERE column <> 'something' 
WHERE column NOT LIKE 'something' 
WHERE column not in('something')

edited May 9, 2011 at 11:44

Stu Thompson

39k19 gold badges112 silver badges156 bronze badges

answered Jul 14, 2010 at 12:34

Dennis Haarbrink

3,7401 gold badge30 silver badges54 bronze badges

Comments

Randy · Accepted Answer · 2010-07-14 12:33:45Z

1

you can use NOT IN

answered Jul 14, 2010 at 12:33

Randy

16.7k2 gold badges40 silver badges56 bronze badges

Comments

Pirozek · Accepted Answer · 2010-07-14 12:57:45Z

1

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)

answered Jul 14, 2010 at 12:57

Pirozek

1,2804 gold badges16 silver badges26 bronze badges

1 Comment

TheNone Over a year ago

Can I insert the values of an array in IN(values of an array)?

Mark Baker · Accepted Answer · 2010-07-14 12:34:08Z

0

WHERE NOT LIKE

WHERE NOT IN

answered Jul 14, 2010 at 12:34

Mark Baker

213k34 gold badges354 silver badges390 bronze badges

Collectives™ on Stack Overflow

Filtering data in Mysql

5 Answers 5

Comments

Comments

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

Comments

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related