Requirement:- In account object i have one field with name approve_Profile__c.
i have 1Lakh of account records. I need to check for this(approve_Profile__c) field for data.
Select id,approve_Profile__c from account where approve_Profile__c like '%system administartor%' or approve_Profile__c like '%standard user%' or approve_Profile__c like '%chatter user%'
But i have 261 profiles with me ,So instead of writing field name and like operator every time ,is there any other way to search profile names in account records