title: How to update json type column value in mysql if I have multi array on the json string
body: <p>I have a json string and I want to edit value of college key in the json. The json string given below which is normally a column value from mysql table.</p>
  
  <p>So my sql query :- select subjectcombination from table where id = 10;</p>
  
  <pre><code>subjectcombination = {"subjectcombination": [{"college": "GOVT. COLLEGE FOR BOYS, REWARI", "district": "REWARI", "college_uuid": "2C533FD3546CF32D2D8D057480006BEE", "district_uuid": "914B62192C43EFB8AA203EF848054856", "course_section": "B.A  I", "college_course_id": "28010"}]}
  </code></pre>
  
  <p>So Please let me know how can I update value of subjectcombination column value with specific college key(I want to update college value). For eg. :- update GOVT. COLLEGE FOR BOYS, REWARI to "ABC"</p>