title: How to convert string value to int in Json field?
body: <p>I am new to this kind of situation.
  I have a column in which I have json data.</p>
  <p><a href="https://i.stack.imgur.com/OWtah.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/OWtah.png" alt="Column of table" /></a></p>
  <p>What am trying to do is to remove the &quot; <strong>double quotes</strong> from all the <code>id</code> values.</p>
  <p>For example <code>[{&quot;id&quot;:&quot;5&quot;,&quot;position&quot;:1}]</code></p>
  <p>Should become <code>[{&quot;id&quot;:5,&quot;position&quot;:1}]</code></p>
  <p>I have tried this query
  <code>update products set category_ids = JSON_SET(category_ids, &quot;$.id&quot;, REPLACE(&quot;$.id&quot;, '&quot;', '')) where id = any_row_id;</code></p>
  <p>But the query is getting implemented successfully and no changes are reflecting.</p>