MySQL query help - searching an integer list
Posted: Sun Oct 31, 2004 6:37 am
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.
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.