title: How To check If mysql DB column has json array of object and contains specific string
body: <p>I have saved the json data in mysql database column which looks like below</p>
  
  <blockquote>
    <p>[{"one":"mg road plot number 711 xyz"},{"two":"dc road plot number 711 xyz"}]</p>
  </blockquote>
  
  <p>json data like above is being stored for all the records with different address. So what I am trying to do is , I want to search all the customer who are having address of mg road.</p>
  
  <p>So I have tried <strong>JSON_SEARCH</strong> and <strong>JSON_CONTAINS</strong> but it always returning me no records found even though there are 2 records in a table. So where I am going wrong.</p>
  
  <pre><code>SELECT * FROM `tbl_clients_data` WHERE JSON_SEARCH(reci_address,'all', "mg road")
  
  
  SELECT * FROM `tbl_clients_data` WHERE JSON_CONTAINS(reci_address, 'mg road', '$.one')
  </code></pre>