title: Cassandra CQL searching for element in list
body: <p>I have a table that has a column of <code>list</code> type (tags):</p>
  
  <pre><code>CREATE TABLE "Videos" (
      video_id UUID,
      title VARCHAR,
      tags LIST&lt;VARCHAR&gt;,
      PRIMARY KEY (video_id, upload_timestamp)
  ) WITH CLUSTERING ORDER BY (upload_timestamp DESC);
  </code></pre>
  
  <p>I have plenty of rows containing various values in the <code>tags</code> column, ie. <code>["outdoor","funny cats","funny mice"]</code>.</p>
  
  <p>I want to perform a <code>SELECT</code> query that will return all rows that contain "funny cats" in the <code>tags</code> column. How can I do that?</p>