I have a query where I am querying a picklist field to gte specific set of values -
 

WHERE <picklist field> like '%value%'

I have now changed the data type to multi select and query gets failed. 

How to replace the original query so that I can get only s specific set of values from the multi select picklist.