A MySQL query question

[eluser]tinawina[/eluser]
Ooooh that's interesting. I will look into that. REGEX is on my learning list this month!

I also was thinking something like this -- since I know my data structure:

Code:

SELECT * FROM table WHERE csv_field LIKE '%; men%' OR LIKE 'men%'

Which I did try and it's looking promising. But the REGEX way is much more bullet-proof (if I can get it right, that is....).

Thanks!