Re: parse by delimiter and search a data field?

[Charles Tronolone]

I'm halfway there I think. Using FIND_IN_SET, I can search a comma-delimited string for a single value, but I haven't figured out how to search the string for multiple values.

SELECT id FROM table WHERE FIND_IN_SET("2", stringOfNums)

That will return any row where "2" present in the stringOfNums after its been parsed. How can I search for multiple values instead of just one?



Edited 1 time(s). Last edit at 04/27/2009 07:44PM by Charles Tronolone.