title: Show the row if the id is in the field separated with commas
body: <blockquote>
    <p><strong>Possible Duplicate:</strong><br>
    <a href="https://stackoverflow.com/questions/2674011/mysql-check-if-numbers-are-in-a-comma-separated-list">mysql check if numbers are in a comma separated list</a>  </p>
  </blockquote>
  
  
  
  <blockquote>
    <p>Note: Please don't tell me to normalize my database</p>
  </blockquote>
  
  <p>Ok so what I need is fetch only rows if the id is present in another table which are comma separated...But am having no idea how to select</p>
  
  <p><code>table1</code></p>
  
  <pre><code>script_id | name | user_id
  +-------------------------+
     33       demo    256
  </code></pre>
  
  <p><code>table2</code></p>
  
  <pre><code>has_access| name |user_id
  +-------------------------+
   33,34,56   demo    256
  </code></pre>
  
  <p>So I want the row to return from <code>table1</code> only if the id exists inside the <code>table2</code> <code>has_access</code> column, moreover I need exact, so if the ID gets 33, or 333 should be different...I need the exact value match</p>