title: How to add, insert and update JSON value into MYSQL?
body: <p>I have one JSON column ('posts') in MYSQL table . When somebody posts something i want to add this data to this column like this  <code>{ &quot;status&quot;: &quot;active&quot;, &quot;id&quot;: &quot;112&quot; }</code></p>
  <p>I can  only do this  &quot;<code>UPDATE users set  posts = ? WHERE id = ? &quot; </code>
  But it deletes and writes data into 'posts' . I need to append data to the beggining of json data.
  My question is simple example of adding json data and updating data (for example where id='112' status='archived')</p>
  <p>Thanks in advance</p>