title: how to use replace function with in clause in mysql
body: <p>I want sql query which gives output as concat string </p>
  
  <p><strong>Sql Query</strong></p>
  
  <pre><code>SELECT GROUP_CONCAT(nm) FROM xyz WHERE xyz.id IN (REPLACE(abc,"|",','))
  </code></pre>
  
  <p>where abc is string like 1|2|3|4 which is ids of xyz table 
  above query only gives nm of 1st id in abc.I thing it creates query like</p>
  
  <pre><code>SELECT GROUP_CONCAT(nm) FROM xyz WHERE xyz.id IN ("1,2,3,4")
  </code></pre>
  
  <p>so (") may creates problem anyone can help.</p>