title: can i use IN operator in MYSQ ON Statement
body: <p>I have this sample mysql statement</p>
  
  <pre><code>SELECT f.* FROM foo f
  INNER JOIN bar b ON b.id IN(f.field_containing_values_separated_by_comma)
  WHERE b.id IN (1,2,3)
  </code></pre>
  
  <p>sample values of (varchar)f.field_containing_values_separated_by_comma
  would be</p>
  
  <pre><code>'1,3,5'
  '2,5,7'
  '10,9'
  '4,5'
  </code></pre>
  
  <p>my expected results would be to fetch the foo records of this f.field_containing_values_separated_by_comma</p>
  
  <pre><code>'1,3,5'
  '2,5,7'
  </code></pre>
  
  <p>any ideas why im not getting it? or where there be any other better ways of doing this? im using PHP as back end by the way</p>
  
  <p>Regards</p>