title: Postgresql - Like query in JSON field
body: <p>I am using postgresql database. i have table with 2 columns(Id, search_term), the search_term is JSON type.</p>
  
  <p>I have data following like this:</p>
  
  <p>Row1:</p>
  
  <pre><code>1 - [{"name":"Weight Loss"},{"name":"Hair gain"},{"name":"Loss money"},{"name":"Loss health"}]
  </code></pre>
  
  <p>Row2:</p>
  
  <pre><code>2 - [{"name":"Abcd"},{"name":"cmko"},{"name":"Loss money"},{"name":"Loss health"}]
  </code></pre>
  
  <p>Row3:</p>
  
  <pre><code>3 - [{"name":"ffuygf"},{"name":"cmko"},{"name":"kooy"} ]
  </code></pre>
  
  <p>Row4:</p>
  
  <pre><code>4 - [{"name":"dog"},{"name":"animal"},{"name":"Loss"}]
  </code></pre>
  
  <p>How can i get all matching values with data->>name="Loss".</p>
  
  <p>O/P should be :</p>
  
  <pre><code>Row 1,2 and 4.
  </code></pre>