title: How can I solve case-sensitive where like statement on json data in Laravel eloquent?
body: <p>I use Laravel 5.6 and mysql database.  </p>
  
  <p>My Laravel eloquent query is like this:</p>
  
  <pre><code>Order::where('information-&gt;owner', 'like', '%'.$receipt.'%')-&gt;paginate(5);
  </code></pre>
  
  <p>Information field is a JSON type.</p>
  
  <pre><code>{"owner": "Chelsea"}
  </code></pre>
  
  <p>If <code>$receipt</code> is <code>Chel</code>, the query returns a result.</p>
  
  <p>But if <code>$receipt</code> is <code>chel</code> or <code>CHEL</code>, the result is empty</p>
  
  <p>How can I solve this problem?</p>