Salesforce SOQL LIKE

In Salesforce SOQL (Salesforce Object Query Language), to combine a LIKE statement with an IN statement, you usually have to split them into separate parts of the query because IN is typically used for exact matches while LIKE is used for pattern matching. However, you can creatively use them together to achieve complex querying.

Let’s assume you want to query the Account object for records where the Name field matches a pattern (using LIKE) and the Industry field is one of several specific values (using IN). Here’s how you could structure such a query:

SELECT Id, Name, Industry FROM Account WHERE (Name LIKE '%Pattern%') AND (Industry IN('Banking', 'Technology', 'Healthcare'))

In this query:

• %Pattern%: Represents a pattern you’re searching for within the Name field. % is a wildcard that matches zero or more characters, so this would match any Name that includes “Pattern” anywhere in it.
• IN ('Banking', 'Technology', 'Healthcare'): Specifies that you want to match records where the Industry field is either “Banking”, “Technology”, or “Healthcare”.

This SOQL query will return all accounts where the name contains “Pattern” and the industry is either Banking, Technology, or Healthcare.

Remember, SOQL is designed to work within the Salesforce environment, so make sure to execute this query in a context where you have permissions to access these records and fields.