write select query for the below requirement

Question

This is my users table:

http://ezinfotec.com/Capture.PNG

I need to select all rows those are not contain 2 in except column. How to write a query for this using php & Mysql.

The result i expect for this query is only return last row only.

Thank you.

Answer 1

Don't store comma separated values in your table, it's very bad practice, nevertheless you can use FIND_IN_SET

SELECT
  *
FROM 
  users
WHERE 
  NOT FIND_IN_SET('2', except)