If it's MySQL, use find_in_set() http://www.bitbybit.dk/carsten/blog/?p=162
PATINDEX would work on MS SQL Server.
WTFy in a lot of situations, but surprising common in a lot of apps.
If it's MySQL, use find_in_set() http://www.bitbybit.dk/carsten/blog/?p=162
PATINDEX would work on MS SQL Server.
WTFy in a lot of situations, but surprising common in a lot of apps.