title: How to update Json data type in MySql?
body: <p>I have column in my table that is Json data type.
  In this column I record Phones data like this:</p>
  
  <p><code>{"0": "044-33565388", "1": "044-33565399", "2": "044-33565311"}</code></p>
  
  <p>For store data like this form, I use <code>textarea</code> and enter each phone number in a new line. Next pass data to php document that parse data something like this:</p>
  
  <pre><code>$phoneList = json_encode( explode("\r\n", $input), JSON_FORCE_OBJECT)
  </code></pre>
  
  <p>And insert data in mysql. Now I want to update or remove some <code>JSON</code> data. I try something like this but got error:</p>
  
  <p><strong>Query:</strong></p>
  
  <pre><code>UPDATE `sellers` SET `seller_phone` = JSON_SET(`seller_phone`, {"0":"33565388","1":"33565399"}) WHERE `seller_id` = 8
  </code></pre>
  
  <p><strong>Error:</strong></p>
  
  <p><em>You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"0":"33565388","1":"33565399","2":"33565311"}) WHERE seller_id = 8' at line 1</em></p>
  
  <p>MySql version: 5.7.9</p>
  
  <p>Now, What can I do to solve this problem?</p>