Can SQL Server's LIKE and IN Operators Be Combined in a Single Clause?

SQL Server: Combining LIKE and IN Operators

SQL Server's LIKE operator searches for patterns, while IN checks for matches within a list of values. Directly combining them in a single WHERE clause isn't possible.

To achieve the equivalent functionality, use multiple LIKE conditions connected with OR:

<code class="language-sql">SELECT * FROM table
WHERE column LIKE 'Text%'
   OR column LIKE 'Link%'
   OR column LIKE 'Hello%'
   OR column LIKE '%World%';</code>

This query retrieves rows where the column matches any of the specified patterns. For instance, it would return rows containing "Text", "Textad", "Text hello", "Link2", "Linkomg", "HelloWorld", and "ThatWorldBusiness". The % wildcard represents any sequence of characters (including zero).

Alternatively, if you have a predefined list of values, using a series of OR conditions with LIKE might be less efficient than other approaches. Consider using a temporary table or common table expression (CTE) for more complex scenarios or large value sets.

The above is the detailed content of Can SQL Server's LIKE and IN Operators Be Combined in a Single Clause?. For more information, please follow other related articles on the PHP Chinese website!