I have a code where in there is a for loop and inside for loop I have a SOQL with 'LIKE' operator,
its like this
for()
{
schemes=[SELECT id, name from somecustom object LIKE :name ]
}
and name is being evaluted everytime for each iteration over for loop
I need to pull soql out of for loop How do i achieve this? Any ideas would be of great help