<p>출처 :&nbsp;<a href="https://stackoverflow.com/questions/30975811/sql-multiple-like-statements" target="_blank">https://stackoverflow.com/questions/30975811/sql-multiple-like-statements</a></p><p><br></p><h2>각 OR로 구분할 때</h2><p><br></p><div style="color: rgb(212, 212, 212); background-color: rgb(30, 30, 30); font-family: Consolas, &quot;Courier New&quot;, monospace; font-size: 14px; line-height: 19px; white-space: pre;"><div><span style="color: #6a9955;">--&nbsp;mariadb&nbsp;테스트&nbsp;진행함</span></div><div><span style="color: #6a9955;">--&nbsp;임시테이블&nbsp;만들고&nbsp;like로&nbsp;검색할&nbsp;검색어들을&nbsp;넣어둔다</span></div><div><span style="color: #6a9955;">--&nbsp;프로시져라면&nbsp;구분자로&nbsp;넘어온&nbsp;것을&nbsp;분리하면&nbsp;될거&nbsp;같다.</span></div><div><span style="color: #569cd6;">CREATE</span>&nbsp;TEMPORARY&nbsp;<span style="color: #569cd6;">TABLE</span>&nbsp;conditions&nbsp;(</div><div>&nbsp;&nbsp;&nbsp;stext&nbsp;<span style="color: #569cd6;">VARCHAR</span>(<span style="color: #b5cea8;">50</span>)&nbsp;<span style="color: #569cd6;">NOT</span>&nbsp;<span style="color: #569cd6;">NULL</span></div><div>);</div><div><span style="color: #569cd6;">INSERT</span>&nbsp;<span style="color: #569cd6;">INTO</span>&nbsp;conditions&nbsp;<span style="color: #569cd6;">VALUES</span>(<span style="color: #ce9178;">'spring'</span>),&nbsp;(<span style="color: #ce9178;">'c#'</span>);</div><br><div><span style="color: #6a9955;">--&nbsp;검색할&nbsp;때&nbsp;EXISTS&nbsp;문장에&nbsp;다음과&nbsp;같이&nbsp;넣어주면&nbsp;잘&nbsp;검색이&nbsp;되더라</span></div><div><span style="color: #569cd6;">SELECT</span>&nbsp;*&nbsp;</div><div><span style="color: #569cd6;">FROM</span>&nbsp;search_table&nbsp;T</div><div><span style="color: #569cd6;">WHERE</span>&nbsp;<span style="color: #569cd6;">EXISTS</span>&nbsp;(&nbsp;<span style="color: #569cd6;">SELECT</span>&nbsp;<span style="color: #b5cea8;">1</span>&nbsp;<span style="color: #569cd6;">FROM</span>&nbsp;conditions&nbsp;<span style="color: #569cd6;">AS</span>&nbsp;con&nbsp;<span style="color: #569cd6;">WHERE</span>&nbsp;T.comlumn&nbsp;<span style="color: #569cd6;">LIKE</span>&nbsp;<span style="color: #dcdcaa;">CONCAT</span>(<span style="color: #ce9178;">'%'</span>,&nbsp;con.stext,&nbsp;<span style="color: #ce9178;">'%'</span>)&nbsp;<span style="color: #569cd6;">LIMIT</span>&nbsp;<span style="color: #b5cea8;">1</span>)</div><br><div><span style="color: #6a9955;">--&nbsp;조인&nbsp;방식으로</span></div><div><span style="color: #569cd6;">SELECT</span>&nbsp;c.Id,&nbsp;c.CreateDate,&nbsp;c.UpdateDate</div><div><span style="color: #569cd6;">FROM</span>&nbsp;search_table&nbsp;<span style="color: #569cd6;">AS</span>&nbsp;c</div><div>&nbsp;&nbsp;&nbsp;&nbsp;<span style="color: #569cd6;">JOIN</span>&nbsp;conditions&nbsp;<span style="color: #569cd6;">AS</span>&nbsp;con&nbsp;<span style="color: #569cd6;">ON</span>&nbsp;c.NormalBody&nbsp;<span style="color: #569cd6;">LIKE</span>&nbsp;<span style="color: #dcdcaa;">CONCAT</span>(<span style="color: #ce9178;">'%'</span>,&nbsp;con.stext,&nbsp;<span style="color: #ce9178;">'%'</span>)</div><div><span style="color: #569cd6;">GROUP&nbsp;BY</span>&nbsp;c.Id,&nbsp;c.CreateDate,&nbsp;c.UpdateDate</div><br><div><span style="color: #6a9955;">--&nbsp;정규식도&nbsp;사용&nbsp;가능</span></div><div><span style="color: #569cd6;">SELECT</span>&nbsp;t.normalbody&nbsp;</div><div><span style="color: #569cd6;">FROM</span>&nbsp;content&nbsp;T</div><div><span style="color: #569cd6;">WHERE</span>&nbsp;t.normalbody&nbsp;REGEXP&nbsp;<span style="color: #ce9178;">'spring|c#'</span></div></div><p><br></p><p><br></p><p><br></p><p><br></p><div style="color: rgb(212, 212, 212); background-color: rgb(30, 30, 30); font-family: Consolas, &quot;Courier New&quot;, monospace; font-size: 14px; line-height: 19px; white-space: pre;"><div><span style="color: #6a9955;">--&nbsp;cte&nbsp;구문을&nbsp;사용한&nbsp;예제인데,&nbsp;저&nbsp;value라는&nbsp;키워드가&nbsp;되는건&nbsp;sql&nbsp;server인가&nbsp;싶다</span></div><div><span style="color: #569cd6;">WITH</span>&nbsp;CTE&nbsp;<span style="color: #569cd6;">AS</span></div><div>(</div><div><span style="color: #569cd6;">SELECT</span>&nbsp;<span style="color: #569cd6;">VALUE</span></div><div><span style="color: #569cd6;">FROM</span>&nbsp;(</div><div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span style="color: #569cd6;">VALUES</span>&nbsp;(<span style="color: #ce9178;">'B79'</span>),&nbsp;(<span style="color: #ce9178;">'BB1'</span>),&nbsp;(<span style="color: #ce9178;">'BB10'</span>),&nbsp;(<span style="color: #ce9178;">'BB11'</span>),&nbsp;(<span style="color: #ce9178;">'BB12'</span>)</div><div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;)&nbsp;V(<span style="color: #569cd6;">VALUE</span>)</div><div>)&nbsp;&nbsp;&nbsp;</div><br><div><span style="color: #569cd6;">SELECT</span>&nbsp;*&nbsp;</div><div><span style="color: #569cd6;">FROM</span>&nbsp;tbl_ClientFile&nbsp;T</div><div><span style="color: #569cd6;">WHERE</span>&nbsp;<span style="color: #569cd6;">EXISTS</span>&nbsp;(&nbsp;<span style="color: #569cd6;">SELECT</span>&nbsp;<span style="color: #569cd6;">TOP</span>&nbsp;<span style="color: #b5cea8;">1</span>&nbsp;<span style="color: #b5cea8;">1</span>&nbsp;<span style="color: #569cd6;">FROM</span>&nbsp;CTE&nbsp;<span style="color: #569cd6;">WHERE</span>&nbsp;T.CLNTPOST1&nbsp;<span style="color: #569cd6;">LIKE</span>&nbsp;CTE.VALUE&nbsp;+&nbsp;<span style="color: #ce9178;">'%'</span>)</div></div><p><br></p><p><br></p><p><br></p><h2>각 AND로 구분할 때</h2><p><br></p><div style="color: rgb(212, 212, 212); background-color: rgb(30, 30, 30); font-family: Consolas, &quot;Courier New&quot;, monospace; font-size: 14px; line-height: 19px; white-space: pre;"><div><span style="color: #6a9955;">--&nbsp;mariadb&nbsp;테스트&nbsp;진행함</span></div><div><span style="color: #6a9955;">--&nbsp;임시테이블&nbsp;만들고&nbsp;like로&nbsp;검색할&nbsp;검색어들을&nbsp;넣어둔다</span></div><div><span style="color: #6a9955;">--&nbsp;프로시져라면&nbsp;구분자로&nbsp;넘어온&nbsp;것을&nbsp;분리하면&nbsp;될거&nbsp;같다.</span></div><div><span style="color: #569cd6;">CREATE</span>&nbsp;TEMPORARY&nbsp;<span style="color: #569cd6;">TABLE</span>&nbsp;conditions&nbsp;(</div><div>&nbsp;&nbsp;&nbsp;stext&nbsp;<span style="color: #569cd6;">VARCHAR</span>(<span style="color: #b5cea8;">50</span>)&nbsp;<span style="color: #569cd6;">NOT</span>&nbsp;<span style="color: #569cd6;">NULL</span></div><div>);</div><div><span style="color: #569cd6;">INSERT</span>&nbsp;<span style="color: #569cd6;">INTO</span>&nbsp;conditions&nbsp;<span style="color: #569cd6;">VALUES</span>(<span style="color: #ce9178;">'spring'</span>),&nbsp;(<span style="color: #ce9178;">'c#'</span>);</div><br><br><div><span style="color: #6a9955;">--&nbsp;조인&nbsp;방식으로</span></div><div><span style="color: #569cd6;">SELECT</span>&nbsp;c.Id,&nbsp;c.CreateDate,&nbsp;c.UpdateDate</div><div><span style="color: #569cd6;">FROM</span>&nbsp;search_table&nbsp;<span style="color: #569cd6;">AS</span>&nbsp;c</div><div>&nbsp;&nbsp;&nbsp;&nbsp;<span style="color: #569cd6;">JOIN</span>&nbsp;conditions&nbsp;<span style="color: #569cd6;">AS</span>&nbsp;con&nbsp;<span style="color: #569cd6;">ON</span>&nbsp;c.NormalBody&nbsp;<span style="color: #569cd6;">LIKE</span>&nbsp;<span style="color: #dcdcaa;">CONCAT</span>(<span style="color: #ce9178;">'%'</span>,&nbsp;con.stext,&nbsp;<span style="color: #ce9178;">'%'</span>)</div><div><span style="color: #569cd6;">GROUP&nbsp;BY</span>&nbsp;c.Id,&nbsp;c.CreateDate,&nbsp;c.UpdateDate</div><div><span style="color: #569cd6;">HAVING</span>&nbsp;<span style="color: #dcdcaa;">COUNT</span>(<span style="color: #569cd6;">DISTINCT</span>&nbsp;con.stext)&nbsp;&gt;=&nbsp;<span style="color: #b5cea8;">2</span>&nbsp;<span style="color: #6a9955;">--&nbsp;앞에&nbsp;2는&nbsp;Conditions&nbsp;테이블의&nbsp;row&nbsp;수</span></div><br><br></div><p><br></p><p><br></p><p><br></p><p><br></p><p><br></p><p><br></p><p><br></p><p><br></p>

[MySQL & MariaDB] 한 쿼리에 여러개의 like 검색 조건 SQL Multiple LIKE Statements