function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
vishalkvishalk 

can we use like with IN where

here i want all websites names in which front will like www.google.com%

example

www.google.com

or

www.google.com/home

 

 

system.debug('#################query==='+[Select Website_Address__c From Employement_Website__c WHERE Website_Address__c LIKE  :UpdtSiteName+'%'  IN :UpdtSiteName]);

//here UpdtSiteName is a set

 

raseshtcsraseshtcs
Dont think it would work.
Try doing this
String idSet = '';
for(Id i: Setofids){
system.debug('i'+i);
if(i != null)
idset+='\''+i+'\',';
}
query = select id from Account where Id IN ('+idset+');

try putting in a like in there and let me know if that worked