title: How can I search json data in mysql?
body: <p>I have description field. The field is json</p>
  
  <p>The contain of the description field is like this :</p>
  
  <pre><code>{
      "address": 
      {
          "street": "street 123", 
          "information": 
          {
              "province": "province 123",
              "regency": "regency 123", 
              "district": "district 123"
          }
      }, 
      "mobileNumber": "123"
  }
  </code></pre>
  
  <p>I want to search province in the json data</p>
  
  <p>I try like this :</p>
  
  <pre><code>SELECT * FROM orders WHERE LOWER(JSON_EXTRACT(description, "$.address.information.province")) LIKE "%prov%"
  </code></pre>
  
  <p>The result is empty</p>
  
  <p>How can I solve this problem?</p>