function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Kaplan EladKaplan Elad 

SOQL Query to look for field contains value

I have a text field on Account, which hold domains spereated with semi colon ( e.g:,,

I want to retreive all the Accounts, where this field contains specific domain (e.g:

Can I do it?
Suraj GharatSuraj Gharat
Hi Kaplan,

You may use "like" keyword in your SOQL with "%" to process the comparison as "contains". For example, SELECT Id FROM Account WHERE Domains LIKE ''
Kaplan EladKaplan Elad
Thanks Suraj,

This will work only when the domain is the same, but when it's a variable, it will not compile (
 Domains LIKE '%domain%'

I succeeded using dynamic Query :  

String soql = 'select Id, RW_Domain__c FROM Account WHERE RW_Domain__c LIKE \'%'+ domainName +'%\'' ;
Suraj GharatSuraj Gharat
Yeah, dynamic SOQL was another option and you used it wisely.

Nevertheless, we could do it through inline SOQL as well, see below code:
String domainName=' or whatever you want';
List<Account> lstAccounts=[select Id, RW_Domain__c FROM Account WHERE RW_Domain__c LIKE :('%'+domainName+'%')] ;