Write a selection request for the following requirement

Question

This is my table users

:

I need to select all rows that do not contain 2 except the column. How to write a query for this using php and Mysql.

The result I am expecting for this query only returns only the last row.

Thank.

+3

Parthasarathi 05 Sep '14 at 6:28

3 answers

Try the following:

SELECT *
FROM users 
WHERE CONCAT(',', except, ',') NOT LIKE '%,2,%'

+1

Saharsh shah 05 Sep '14 at 6:30

this should work for you

SELECT *
FROM table
WHERE table.except NOT LIKE '%,2%'
OR table.except NOT LIKE '%2,%';

0

user3231903 05 Sep '14 at 6:33

Ende neu · Accepted Answer · 2014-09-05T06:30:48+0000

Don't store the values in comma in your table, this is very bad practice, however you can use FIND_IN_SET

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