title: Mysql JSON Data type : want to replace multiple array json value i.e update the record of nested json
body: <p>in my mysql db i store the value like :</p>
  
  <pre><code>Table name : access_record
  id | access
  1  | [{"camp_id":"1","permission":"r,w","read_unread_status":"0"},
        {"camp_id":"2","permission":"r,w","read_unread_status":"0"}]
  </code></pre>
  
  <p>I want to update the record id=1 which has camp_id = 2 
  &amp; update value of read_unread_status = 1</p>
  
  <p>please help me to find the solution.</p>
  
  <p>I was try like below which is select query (testing): </p>
  
  <pre><code>SELECT id,(SELECT json_search(access-&gt;'$[*].camp_id','all',2)) FROM access_record WHERE json_search(access-&gt;'$[*].camp_id','all',2) IS NOT NULL AND id = 1
  </code></pre>