I am working with a database that has multiple values stored as CSV in a varchar field such as:

value1,value2,value3 or with spaces value1, value2, value3

Is there an expression in HQL that I can employ so that I can build queries like:

select * from mytable where 'value2' in some_exp(csvfield)

I'd prefer not to use LIKE because of false positives, searching for doctor would return doctoral, etc.

Thanks

Is this thing on?