title: Can MySQL split a column?
body: <p>I have a column that has comma separated data:</p>
  <pre><code>1,2,3
  3,2,1
  4,5,6
  5,5,5
  </code></pre>
  <p>I'm trying to run a search that would query each value of the CSV string individually.</p>
  <pre><code>0&lt;first&lt;5   and  1&lt;second&lt;3  and  2&lt;third&lt;4 
  </code></pre>
  <p>I get that I could return all queries and split it myself and compare it myself. I'm curious if there is a way to do this so MySQL does that processing work.</p>
  <p>Thanks!</p>