Here is my situation, I want to query multi-select picklists in static soql, I have done this in dynamic soql, but in static soql, I don't know how to do it?
String categories = 'Featured, Super Featured';List<Product2> products = [select Category__c from Product2 where Category__c includes (:categories)];
In this way, I want to select all the products include Featured or Super Featured category, but I cannot get the right records.
But in this way, I got the right records.
List<Product2> products = [select Category__c from Product2 where Category__c includes ('Featured','Super Featured')];
Is there anyone can help me this problem? Thanks in advance!!