How to match comma separated values in mysql database

Question

I have a string of ids like tsid = '1,2,3,4'

Now i want to match this tsid with a column of a mysql database. The values in column ia also comma separated like this '1,2,3,4,5,6,7,8,9,10'

Now i want a sql query which finds the tsid in a column.

I have tried tsid like '%".$tsIdsAll."%'" But this is not fetching right result.How to do this?

Thanks

Only very painfully. That is why you should use a junction table instead of storing ids in a string. — Gordon Linoff, Dec 04 '14 at 11:53
First, retrieve the comma seperated string. Then explode the string and loop it trough, matching it. — Peter, Dec 04 '14 at 11:53
Peter i was thinking to do this. But keeping it as my last option. Any other idea? — New user, Dec 04 '14 at 11:54
If you want to do it in mysql, check this answer: http://stackoverflow.com/questions/2602252/mysql-query-string-contains — Peter, Dec 04 '14 at 11:56
Pols if we have tsid '1,2' and in db we have '21,22'. this will also match up — New user, Dec 04 '14 at 12:24

score 0 · Answer 1 · answered Dec 04 '14 at 11:56

0

answered Dec 04 '14 at 11:56

White Marcus

ofcourse Marcus. I wanted to do it in mysql way. otherwise i will do it in this way – New user Dec 04 '14 at 12:23
k mate. but i think mysql only has the LIKE (%) keyword. but it doesn't produce the exact result. – White Marcus Dec 04 '14 at 12:29

1 Answers1