Question: I want to execute a query where I can find one ID in a list of ID.

table `user` 

```
id_user | name  | id_site
-------------------------
1       | james | 1, 2, 3 
1       | brad  | 1, 3 
1       | suko  | 4, 5

```

and my query (doesn't work)

```
SELECT * FROM `user` WHERE 3 IN (`id_site`) 

```

This query work (but doesn't do the job) 

```
SELECT * FROM `user` WHERE 3 IN (1, 2, 3, 4, 6) 

```

Answer: 
Try this: [FIND\_IN\_SET(str,strlist)](http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_find-in-set)
The problem is that you are searching within several lists. 

You need something more like:

```
SELECT * FROM `user` WHERE id_site LIKE '%3%';

```

However, that will also select 33, 333 and 345 so you want some more advanced text parsing.