search comma separated db column

[Jon Hollis]

I need a query string to search a column that contains a comma separated list of integers.

I've got this:

SELECT * FROM `jos_content` WHERE cat_tag LIKE '%57%'

Which is fine until I need to pull out results with numbers less than ten. For example, if I need to search for instances of "7", I could get anything that contains 57 or 27 or 7 etc. I want to search for the number esplicitly, all of it, the whole number, nothing greater or smaller.

Maybe the answer lies with IN or FIND_IN_SET but I can't get these to work.