Hi, I hope someone can help me. I've been looking half the night for a solution but I'm at a dead end.
I have a set of records, each has a field with a list of integers. I would like throw a list of integers at a search query and get matching rows.
example records:
1 - 1,3,5,8,10
2 - 2,51,59
3 - 4,9,10,23
So if I searched for "8,23,99" the query should return records 1 and 3.
I have tried "LIKE", I've tried "IN", and I've tried FULLTEXT searches. To use fulltext, I would have to change the minimum search length to 1, which feels like the wrong thing to do.
If anyone has any suggestions they will be much appreciated, thanks.
MySQL query help - searching an integer list
Moderator: General Moderators