title: WHERE IN with subquery NOT WORKING as expected
body: <p>I am trying to get result from my categories table using the parent path i have created.
  When i launch the request WHERE IN with manual data it's working perfectly.
  When i am trying the same request dynamically with subquery, i got only one result instead of 4 expected.
  I do not understand why, can you help me ?</p>
  
  <p><a href="http://sqlfiddle.com/#!2/88b68/6" rel="nofollow">http://sqlfiddle.com/#!2/88b68/6</a></p>
  
  <pre><code>/*Working query*/
  SELECT t.id_categorie FROM t 
  WHERE t.id_categorie IN (1396,1399,1403,1412)
  
  /*Not working by subquery ??*/
  SELECT cat.id_categorie FROM t as cat
  WHERE 
  cat.id_categorie IN (SELECT REPLACE(t.path,'.',',') FROM t WHERE t.id_categorie = 1412)
  </code></pre>
  
  <p>Thanks by advance,</p>
  
  <p>Regards,</p>