How to exclude a specific row identifier from query results?

Question

I have a Member table in which I have three rows that have member_idboth admins, adminand manager. Now I want to select all the members from the table, excluding these three member_id.

For this, I tried the following query:

SELECT * FROM `Member` 
 WHERE Member.member_id NOT IN ( 
          SELECT member_id 
            FROM Member 
           WHERE Member.member_id = 'manager' 
             AND Member.member_id = 'admins' 
             AND Member.member_id = 'admin' 
    )

But still I can see these three lines selected as a result.

How can i do this?

Answer 1

You need to write a query as shown below:

SELECT * FROM `Member` WHERE Member.member_id NOT IN ('admins' , 'admin','manager');

Answer 2

Try to do it right. Use Pratik for best performance.

 SELECT * FROM `Member` WHERE Member.member_id NOT IN ( SELECT member_id FROM Member WHERE Member.member_id = 'manager' OR Member.member_id = 'admins' OR Member.member_id = 'admin' )