[SOLVED] Mysql query to locate users with specific Query Check Box (Multiple) selected

I have a CB field of type Query Check Box (Multiple) in use.

When users select a few checkboxes, the field data ends up with the IDs delimited by "|*|".

I need to be able to query this data using mysql directly (and can't do it within a PHP code block ... I need it to actually be part of a mysql view that I create).

I know that if this were a comma-delimited list, I could just use WHERE IN(field); however, because CB uses a 'unique' delimiter, the WHERE IN syntax doesn't work.

Although this isn't a specific CB question, I've not run across any means (other than complicated user defined functions) to perform this type of a query.

Do you have some 'secret' solution for building queries like this on the multiple check box query field type?

Use LIKE with wildcards is the simplest approach, but your values can not contain another value. Example as follows.


Now if you've VALUE|*|VALUE1 then the above will match both. Another approach is to use FIND_IN_SET and convert the delimiter. Example as follows.

The FIND_IN_SET with the converted delimiter option was the PERFECT solution. That little snippet made the case work AND gives me all sorts of ideas for future applications.
THANKS!!!!