I want to get all email addresses which contain @gnail.com, @gmeil.com or @gmai.com from DB. I have access only to Workbench and Salesforce Inspector and will need to execute the query periodically.
I tried code as in Multiple LIKE in SOQL
SELECT CreatedDate,PersonEmail FROM Account WHERE Country__c = 'UA' AND Account.PersonEmail LIKE '%@gnail.com%' OR Account.PersonEmail LIKE '%@gmeil.com%' OR Account.PersonEmail LIKE '%@gmai.com%'
Error: unexpected token: OR
Also I tried a variant:
SELECT CreatedDate,PersonEmail FROM Account WHERE Country__c = 'UA' AND PersonEmail LIKE ('%@gnail.com%', '%@gmeil.com%', '%@gmai.com%')
gives an error: Bind variables only allowed in Apex code