title: MySql Select rows where value IN comma-delimited column
body: <p>I'm trying do something like this:</p>
  
  <pre><code>SELECT * FROM table WHERE column IN (1,2,3)
  </code></pre>
  
  <p>but in place of 1,2,3 I want to use a column from another table that contains a comma-delimited list just like "1,2,3" above.</p>
  
  <p>I have tried to do this:</p>
  
  <pre><code>SELECT 
    GROUP_CONCAT(a.eating_area SEPARATOR ', ') 
  FROM table_areas a 
  WHERE a.eating_area_id IN (
    SELECT
      o.eating_area_ids 
    FROM table_offers o WHERE o.rid=1
  )
  </code></pre>
  
  <p>however this only returns the value associated with 1, and not 2 or 3. Can this be done or is there another way to do this?</p>
  
  <p>Many thanks</p>