title: Search for a particular text in a string - Hive
body: <pre><code>/google/gmail/inbox
   /google/drive/map
   /google/apps
   /yahoo/news/cricket
   /yahoo/mail/
   /yahoo/sports
   /wiki/ind/jack
   /wiki/us/jil
  </code></pre>
  
  <p>I need to get the required page groups. If i search for page group starting with 'google' using hive query, I need to get the data of the first 3 rows.</p>
  
  <pre><code>/google/gmail/inbox
   /google/drive/map
   /google/apps
  </code></pre>
  
  <p>In this way I need to get the data based on page group.</p>
  
  <hr>
  
  <p>I searched for the string using like function.</p>
  
  <pre><code>select * from table where field like '%/google/%';
  </code></pre>