title: group_concat result not work in IN condition
body: <p>Is there any possible way to put result of group_concat in IN condition of SQL query.</p>
  
  <p>Here in network master table i have comma separated fields in industryId column.
  Like,</p>
  
  <pre><code>userId     industryId
  123        3831
  123        2832,3832
  123        3833
  </code></pre>
  
  <p>Example:</p>
  
  <blockquote>
    <p>select group_concat(industryId order by cId SEPARATOR ',') from
    network_master where userId = 123</p>
  </blockquote>
  
  <p>and it gives me this type of output 3831,2832,3832,3833
  I got this type of output using upper query,</p>
  
  <pre><code>userId      industryId
  123         3831,2832,3832,3833
  </code></pre>
  
  <p>and now i done this things,</p>
  
  <blockquote>
    <p>select * from industry_master where industryId in  (select
    group_concat(industryId order by cId SEPARATOR ',') from
    network_master where userId =123  group by userId);</p>
  </blockquote>
  
  <p>In this query result, I got details output of industryId=3831 only. I did not get other Ids output.</p>
  
  <p>I need all the industryId output in this query. How to i achieve this things in <strong>mysql</strong>.</p>
  
  <p>Any help would be appreciated.</p>