title: How to where like on JSON data
body: <p>I have a table user where in a column billing containing different JSON data. </p>
  
  <p>I want to get only the user where his/her JSON data containing <code>"ContractEnd":"0"</code>
  some of it containing <code>"ContractEnd":"1"</code>, <code>"ContractEnd":"2"</code> i want only <code>"ContractEnd":"0"</code></p>
  
  <p>I tried like this </p>
  
  <pre><code>$user = App\User-&gt;whereRaw("(billing LIKE '%"ContractEnd":"0"%')")-&gt;get();
  </code></pre>
  
  <p>but it returns an error.</p>
  
  <pre><code>billing LIKE '%"ContractEnd":"0"%' 
  </code></pre>
  
  <p>needs to be <code>billing ="ContractEnd":"0"</code> </p>
  
  <p>How do I do it?</p>