title: How do I replace only part of string after specific string keeping part of string to replace in SQL?
body: <p>I have a table named user with column data. Data contains very long string (it's a JSON nested into data column as a string). I want to change all values of <strong>fontSize</strong> key to be an int in all cases where fontSize value is a string, but the int value must be preserved. 
  So basically this is what I want to do:</p>
  
  <pre><code>{
    "id": 1,
    "name": "New Window",
    "resources": {
      "widgets": [
        {
          "id": 1,
          "color": "#ffffff",
          "fontSize": "5",
          "width": 150
        },
        {
          "id": 2,
          "color": "#aaaaaa",
          "fontSize": "10",
          "width": 200
        }
      ]
    }
  }
  </code></pre>
  
  <p>change to:</p>
  
  <pre><code>{
    "id": 1,
    "name": "New Window",
    "resources": {
      "widgets": [
        {
          "id": 1,
          "color": "#ffffff",
          "fontSize": 5,
          "width": 150
        },
        {
          "id": 2,
          "color": "#aaaaaa",
          "fontSize": 10,
          "width": 200
        }
      ]
    }
  }
  </code></pre>
  
  <p>in all cases where fontSize value is a string (in some cases it is already an integer). Values of fontsize are different and they must be preserved.</p>
  
  <p>I know the logic. I have to find all cases in table user where data column like '%"fontSize":"%', then delete first " after "fontSize": pattern and first " after numeric. How could I do this ? Is it possible in SQL ? Thanks for your help!</p>