title: Multiple LIKE in SQL
body: <p>I wanted to search through multiple rows and obtain the row that contains a particular item.</p>
  
  <p>The table in mySQL is setup so each id has a unique list (comma-delimited) of values per row.</p>
  
  <p>Ex:</p>
  
  <pre><code>id | order
  1  | 1,3,8,19,34,2,38
  2  | 4,7,2,190,38
  </code></pre>
  
  <p>Now if I wanted to pull the row that contained just the number 19 how would I go about doing this?  The possibilities I could figure in the list with a LIKE condition would be:</p>
  
  <pre><code>19,     &lt;-- 19 at the start of the list
  ,19     &lt;-- 19 at the end of the list
  ,19,    &lt;-- 19 inside the list
  </code></pre>
  
  <p>I tried the following and I cannot obtain any results, Thank you for your help!</p>
  
  <pre><code>SELECT *
  FROM categories
  WHERE order LIKE '19,%' OR '%,19%' OR '%,19%'
  LIMIT 0 , 30
  </code></pre>