+ Start a Discussion
MC34MC34 

Need help with SOQL query in workbench

Hi I am trying to extract the contacts with accounts where the clean mobile numbers are following (there are some 100 clean mobile numbers I have in hand) eg. 999999999,777777777..so on. Bascically I need to fetch those contact ids with their account ids. 

The query I am working is like: 

SELECTAccountId,Account_Number__c,Clean_Mobile_Number__c,Clean_Phone_Number__c,Company__c,Contact_ID__c,FirstName,Id,LastName,Name FROM Contact WHERE Clean_Mobile_Number__c IN (999999999,777777777...)
What is the best way to write this query? Thank you, Mit 
 
AbhinavAbhinav (Salesforce Developers) 
Is it fine too use Apex Execute for this under utilities?