title: MySql REGEXP to match two comma separated strings
body: <p>I have a table containing following values :</p>
  
  <pre><code>id    |    value      |
  -----------------------
  1     | 1,2,5,8,12,20 |    
  2     | 11,25,26,28   |    
  -----------------------
  </code></pre>
  
  <p>now I want to search some comma separated IDs e.g. '1,3,6,7,11' from above value column e.g.</p>
  
  <pre><code>SELECT id FROM tbl_name  
  WHERE value REGEXP '*some reg exp goes here containing 1,3,6,7,11*'
  LIMIT 1,0;
  
  SELECT id FROM tbl_name  
  WHERE value REGEXP '*some reg exp goes here containing 3,6,27,15*'
  LIMIT 1,0;
  </code></pre>
  
  <p>above 1st query should return 1 while the 2nd should return NULL  </p>
  
  <p>I am new with regular expressions can anyone help. Thanks</p>