[TYPO3-english] DB Select

[JoH asenau]

>> WHERE CONCAT(',',category,',') LIKE '%,X,%'
>
> That wouldn't match values like 'X,2,3' where X is the desired value,
> would it?

... of course it would since CONCAT(',','X,2,3',',') would result in
',X,2,3,' and this would match '%,X,%', which might help at least for those
old-style TYPO3-relations that are i.e used to assign usergroups to
elements.

HTH

Joey

-- 
Wenn man keine Ahnung hat: Einfach mal Fresse halten!
(If you have no clues: simply shut your gob sometimes!)
Dieter Nuhr, German comedian
Xing: http://contact.cybercraft.de
Twitter: http://twitter.com/bunnyfield
TYPO3 cookbook (2nd edition): http://www.typo3experts.com
TYPO3 workshops: http://workshops.eqony.com