title: MySQL insert JSON data type in existing row
body: <p>I have a column in my MySQL table that is type json. I am trying to update a row with a SQL script.</p>
  
  <p>This is the JSON I am attempting to insert into the column</p>
  
  <pre><code>{
    "HE": [{
      "isbn": "1234",
      "type": "Some text"
    }],
    "HS": []
  }
  </code></pre>
  
  <p>I have tried quite a few different ways with no luck, below is the method of updating a row I am most familiar with.</p>
  
  <pre><code>UPDATE `textbooks` 
  SET `isbns` = {"HE":[{"isbn":"9781337763639","type":"Single Term HW &amp; 
  eBook University"}],"HS":[]} 
  WHERE `id` = 939;
  </code></pre>