title: Oracle SQL select where like value of row
body: <p>So I have 2 tables: </p>
  
  <p>festival table: with column <strong>NAME</strong> </p>
  
  <pre><code>---------------------
  NAME
  ---------------------
  1. ultra music
  2. coachella
  </code></pre>
  
  <p>and Querydata with column: <strong>QUERY</strong></p>
  
  <pre><code>----------------------
  QUERY
  ----------------------
  1. xyz
  2. coachella festival
  3. abc
  4. ultra music festival
  </code></pre>
  
  <p>So I want to count all the occurrences of each festival in the <code>querydata</code> table.</p>
  
  <p>I mean I could go through the <code>Querydata</code> table and search for every single festival name on it's own but I'm really looking for convenient way to do this.</p>
  
  <pre><code>SELECT QUERY FROM QUERYDATA 
  WHERE QUERY LIKE '%coachella%'
  AND QUERY LIKE '%festival%'
  </code></pre>
  
  <p>Please help me I'm really stuck on this one !
  Cheers</p>