title: Is it possible to use cql to query collections in a row?
body: <p>Assuming you have movies as a row, and a list of categories, i.e.</p>
  
  <pre><code>create table movie(
      uuid timeuuid,
      name text,
      category list&lt;text&gt;
      primary key (uuid)
  );
  
  insert into movie (uuid,name,category) values(now(), 'my movie', ['romance','comedy']);
  insert into movie (uuid,name,category) values(now(), 'other movie', ['action','comedy']);
  </code></pre>
  
  <p>Is it possible to efficiently do something like:</p>
  
  <pre><code>select * from movie where category='comedy'
  select * from movie where category='comedy' and category='action'
  </code></pre>
  
  <p>This use case is the most common query against our MySQL database.</p>