title: How to compare comma separated values in mysql as exact match
body: <p>Suppose I have table name called group and in which because of some reason I've comma separated values in field X now I want to compare an array with that field in mysql if array matches exact same then result should return.</p>
  
  <p>For example :
  I've a row</p>
  
  <blockquote>
    <p>1 - a,b,c 2 - x,y,z</p>
  </blockquote>
  
  <p>so if array contains :</p>
  
  <pre><code>array(b,a,c) // Return row 1 
  array(z,x,y) // Return row 2 
  array(a,b) // Return false
  </code></pre>