title: Mysql Query where field in (select column value) not works
body: <p>I am trying to get some values with the help of where clause and the value for that where clause is the values from a record in the same table.</p>
  
  <p>For example,</p>
  
  <p><code>select requestedusers from users where username = 'xyz'</code></p>
  
  <p>When I run the above query it gives me result like <code>abc,mno,tuv</code></p>
  
  <p>I used that result in another query like <code>select data from users where username in (abc,mno,tuv)</code> and I am getting the finalized result.</p>
  
  <p>But I need to obtain the finalized result in a single query like <code>select data from users where username in (select requestedusers from users where username = 'xyz');</code>. </p>
  
  <p>When I try to run query like this it return me empty set.</p>