title: Replace multiple string values in the same custom field in SQL db
body: <p>I have a custom field called 'variations', and inside it has colors (comma seperated) like "Black, Red, Blue".
  I need to replace the colors into another language on a daily basis via a cron job. For one single color change, this works to change Black into Noir:</p>
  
  <pre><code>UPDATE `wp_postmeta` 
  SET `meta_value` = replace(meta_value, 'Black', 'Noir')
  WHERE `meta_key` LIKE 'variations'
  </code></pre>
  
  <p>Everything is all and well but i would like to replace more than one color inside this same query. I prefer not to have 20 similar queries to cover all 20 possible color changes.</p>
  
  <p>Is something like this possible?</p>
  
  <pre><code>UPDATE `wp_postmeta` 
  SET `meta_value` = replace(meta_value, 'Black', 'Noir'), (meta_value, 'Green', 'Vert') 
  WHERE `meta_key` LIKE 'variations'   
  </code></pre>
  
  <p>I don't have a test system and i don't want to possibly mess up my database.</p>