title: MySQL: Select inside IN() function
body: <p>I have table:</p>
  <pre><code>tasks_whatwhom | CREATE TABLE tasks_whatwhom (
  id int(3) NOT NULL AUTO_INCREMENT, 
  name varchar(150) NOT NULL,
    message varchar(255) NOT NULL,
    filial_list text,
    client_list text,
    PRIMARY KEY (id),
    UNIQUE KEY name (`name`)
  ) ENGINE=Aria AUTO_INCREMENT=53 DEFAULT CHARSET=utf8 PAGE_CHECKSUM=1
  </code></pre>
  <p>Field <code>filial_list</code> looks like <code>'12,14'</code>.</p>
  <p>There is another table <code>filials</code> which contains addition information about filials.</p>
  <p>SQL statement:</p>
  <pre><code>select * from filials where id IN(14,12) and status=1;
  </code></pre>
  <p>works as expect but below - returns zero. I don't understand why?</p>
  <pre><code>select * from filials where id IN(select filial_list from tasks_whatwhom) and status=1;
  </code></pre>