I have a table of Member, in that I have three rows which has
member_id
admins
admin
manager
member_id
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'
)
You need to write query like below :
SELECT * FROM `Member` WHERE Member.member_id NOT IN ('admins' , 'admin','manager');