Due to shield encryption, I have to get rid of any SOQL queries filtered with encrypted fields. Thought is to remove the filter from soql and validate the retrieved soql results against the searchKey using a string method. I am able to get replacements for = (->equals) and IN (->contains) operators but did not find any for LIKE operator. Could anyone please help me with any other way? Is this the efficient way of doing?
Select Id from Account where Name LIKE: searchKey
where searchKey is a string with wildcards
Please ignore any syntax errors