title: MySQL - is it possible to update only part of value from current column?
body: <p>Here is an example table on which I would like to execute a query:</p>
  
  <pre><code>Structure of table_1
  number | photos (CHAR,4)
  1234   | 1210
  </code></pre>
  
  <p>I would like to update value from column <code>photos</code>, but without changing the whole value. I would like change, for example, only third character to "2" without knowing the whole value. How can I do that?</p>
  
  <p><em>I know I could do that in this way described below, but the problem is the value may be variable and it is a column type CHAR, not INT.</em></p>
  
  <pre><code>UPDATE table_1 SET photos = (photos + 10) where number='1234'
  </code></pre>