> WHERE CONCAT(',',category,',') LIKE '%,X,%'
That wouldn't match values like 'X,2,3' where X is the desired value,
would it?
Anyway, no need to discuss this further, I think, it's clear that this
is not the right way.
--
Jan Bednarik
www.bednarik.org - web about Typo3 in czech