Hello,

empno | loc_ids [varchar]
----------------------
38084 | 12,10,20
38085 | 18,12

Now if issue the following query

Code:
SELECT *
FROM `table`
WHERE `loc_ids` =12
it returns 38084. but i feel this is wrong
how come "12,10,20" = 12?