title: Is there a fast way to update one json column data with MySQL?
body: <p>There is a column in a table as</p>
  <pre><code>table: articles
  rows:  id           type: int(11)
         json_data    type: json
         created_at   type: datetime
         updated_at   type: datetime
  </code></pre>
  <p>Now the <code>json_data</code> is</p>
  <pre><code>{
     &quot;version&quot;:&quot;1&quot;,
     &quot;title&quot;:&quot;A good product&quot;,
     &quot;body&quot;:&quot;Very good&quot;,
     &quot;published_at&quot;:null
  }
  </code></pre>
  <p>Want to update its data to new json schema format based on the current meta data:</p>
  <pre><code>{
     &quot;version&quot;:&quot;2&quot;,
     &quot;items&quot;:[
        {
           &quot;title&quot;:&quot;A good product&quot;,
           &quot;body&quot;:&quot;Very good&quot;,
           &quot;published_at&quot;:null
        }
     ]
  }
  </code></pre>
  <p>How to do it if not use a programming language. Is it possible to do it by MySQL's procedure?</p>