SOQL Query Like With Multiple Values

Biswajeet March 31, 2020 No Comments

Sample Code:

Set<String> accountNameMatches = new Set<String> { 'A%', 'B%', '%C%', '%D' };
List<Account> accList = [SELECT Id FROM Account WHERE Name LIKE :accountNameMatches];
system.debug('accList-' + accList);

Use Like With List And Set Collections In SOQL Queries

Biswajeet June 1, 2015 No Comments

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];

Biswajeet Samal's Blog

Sharing My IT Experience

Tag Archives: LIKE

SOQL Query Like With Multiple Values