title: MYSQL - update text values in table without select, with case (updates in one query)
body: <p>I have got an issue with problem named in topic. 
  I am trying to update multiple rows in table in one query depending on specific id of row. Unfortunatelly rows I want to update are text type of data (with numeric data it's easy). This is my query:</p>
  
  <pre><code>UPDATE table SET column = CASE
  WHEN id = 2 THEN column = column + ', 100'
  WHEN id = 3 THEN column = column + ', 10'
  [...]
  ELSE column
  END;
  </code></pre>
  
  <p>Data in column is imploded from php so it looks like:</p>
  
  <pre><code>id | column
  ------------
   2 | 5, 6, 20
   3 | 7, 12, 200
  </code></pre>
  
  <p>After executing a query i would like to have:</p>
  
  <pre><code>id | column
  ------------
   2 | 5, 6, 20, 100
   3 | 7, 12, 200, 10
  </code></pre>
  
  <p>How to add those values to specified rows? For now it changes 'column' row with id 2 and 3 to 0 (like it was an integer type of value).</p>
  
  <p>I also would like to ask you how to erase specific value from column isntead of adding it:</p>
  
  <pre><code>id | column
  ------------
   2 | 5, 7, 20
   3 | 7, 12, 200
  </code></pre>
  
  <p>and i want to remove '7, ' from both rows - with id 2 and 3 so after query it looks like this:</p>
  
  <pre><code>id | column
  ------------
   2 | 5, 20
   3 | 12, 200
  </code></pre>
  
  <p>Any help would be appreciated - i got stuck with it :/</p>