Get multiple id on multiple value in string with sql?

Question

I have one table like

tbl

---------------------
id  users   name
---------------------
1   2,3     acc1
2   4       acc2
3   2,4,1   acc3
4   4,1     acc4

In this table I want to get id and name by users i.e user [2] have which id and name

Suppose I pass user [2] then i get result id is 1 and 3 and name acc1 and acc3.

Answer 1

Try this will work for you

    SELECT id,name FROM yourtablename WHERE `users` LIKE '%2%';