Use Like With List And Set Collections In SOQL Queries

Biswajeet   June 1, 2015   No Comments on Use Like With List And Set Collections In SOQL Queries

Set Collection in Like:

Set<String> accountNames = new Set<String>{'%Sam%', '%App%', '%Len%','%Nok%'};
List<Account> accList = [Select Id, Name From Account Where Name LIKE :accountNames];

List Collection in Like:

List<String> accountNameList = new List<String>{'%Sam%', '%App%', '%Len%','%Nok%'};
List<Account> accList = [Select Id, Name From Account Where Name LIKE :accountNameList];