trevor1940

<div>
Well, normalization is your friend. Otherwise you need a string split function. Using the built-in (SQL Server 2016+): 
 

<pre><code class="code-10 nolinks" id="code-20-42542090-1">DECLARE @Unnormalized TABLE
 (
 ID INT IDENTITY ,
 Payload NVARCHAR(255) NOT NULL
 );

INSERT INTO @Unnormalized ( Payload )
VALUES ( N'abc,efg,xyz' ) ,
 ( N'abc,xyz' ) ,
 ( N'efg,xyz' ) ,
 ( N'xyz' ) ,
 ( N'efg' ) ,
 ( N'abc' );

SELECT *
FROM @Unnormalized U
WHERE EXISTS ( SELECT *
 FROM STRING_SPLIT(U.Payload, ',') SS
 WHERE SS.value IN ( 'abc', 'xyz' ));
</code></pre>
</div>

<div>
I went with first comment because it is simpler to code via external perl script 
Also The second comment mentions &nbsp;Using the built-in (SQL Server 2016+) unsure if MYSQL has this function
</div>

<div>
<div class="content wysiwyg-content">
Hi 
 
Can you combine LIKE and IN within a single MYSQL query? 
 
I have a list of codes I need to search for something like this 
 

<pre><code class="code-1 nolinks" id="code-10-29095945-1">select * FROM mytable WHERE codes LIKE '%ABC%' OR code LIKE '%XYZ%';
</code></pre>
 
The problem is the column codes &nbsp;contains a coma separated list eg &quot;ABC,EFG,XYZ&quot; &nbsp;so a standard IN clause wont work
</div>
</div>

Hi

Can you combine LIKE and IN within a single MYSQL query?

I have a list of codes I need to search for something like this

(CODE)

The problem is the column codes  contains a coma separated list eg "ABC,EFG,XYZ"  so a standard IN clause wont work

SQL: Can you combine LIKE and IN within a single query?

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.