Is it possible to query using SOQL for a substring on a multi-select picklist? LIKE seems to not work on multi-select picklists.

Example:

MultiSelectPicklist = 'myfavoritefruitisapple;myfavoritecolorisgreen;ihatered'

I'd want to query using WHERE and search for the substring 'favorite' such that it will pick up anything with 'myfavoritefruitisapple' or 'myfavoritecolorisgreen' but not pick up the 'ihatered' people.

Is something like this possible?

Thanks!

Is it possible to query using SOQL for a substring on a multi-select picklist? LIKE seems to not work on multi-select picklists.

Example:

MultiSelectPicklist = 'myfavoritefruitisapple;myfavoritecolorisgreen;ihatered'

I'd want to query using WHERE and search for the substring 'favorite' such that it will pick up anything with 'myfavoritefruitisapple' or 'myfavoritecolorisgreen' but not pick up the 'ihatered' people.

Is something like this possible?

Thanks!