mysql query to fetch matching records

Question

Table_One

id name groupid
1  AAA   5,6
2  BBB   5,7
3  CCC   15

I am trying to make a query something like:

select * from Table_One 
where Table_One.groupid like '%".$objectData[groupid]."%'

such that if value of $objectData[groupid] is 5 then result should be

1  AAA   5,6
2  BBB   5,7

Similarly, if value of $objectData[groupid] is 6 then result should be

1  AAA   5,6

and, if value of $objectData[groupid] is 7 then result should be

2  BBB   5,7

Either use FIND_IN_SET instead of LIKE, or restructure your database and normalize your multiple group_ids into a separate relational table — Mark Baker
– Mark Baker, Commented Sep 27, 2012 at 6:48

Omesh · Accepted Answer · 2012-09-27 06:41:38Z

2

Instead of using LIKE use FIND_IN_SET function, try this:

SELECT * 
FROM Table_One 
WHERE FIND_IN_SET(".$objectData[groupid].", Table_One.groupid);

answered Sep 27, 2012 at 6:41

Omesh

29.4k6 gold badges44 silver badges51 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1