title: mysql select replace function
body: <p>I have this problem. I have two tables from which I want to extrapolate the values, specifically in a field of a table are the ids of the second table separated by;
  Using this procedure:</p>
  
  <pre><code>SELECT name 
    FROM tab1
   WHERE id in (SELECT REPLACE(field,";",",") as idresult 
                  from tab2 
                 where tab2.id=1)
  </code></pre>
  
  <p>From this query I expect more rows because in the tab2 field there are these values (1;2;3;4;5)</p>
  
  <p>If the same procedure you run without Select Replace I get the correct 
  results ie::</p>
  
  <pre><code>SELECT name FROM tab1
  WHERE id in (1,2,3,4,5) 
  </code></pre>
  
  <p>it's right. Should I use the replacement you have suggestions?</p>