title: Update multiple columns of a table conditionally in a single command
body: <p>I have a table that contains the columns <code>name</code>, <code>client_name</code> and <code>requester_name</code>. I need to update values of these columns from "Mic" to "Michael".</p>
  
  <p>Here are some records that should be updated:</p>
  
  <pre><code>name  | client_name |  requester_name
  ------+-------------+----------------
  Mic   | Jerry       | Jack
  Jack  | Mic         | Mic
  Jerry | Jack        | Mic
  </code></pre>
  
  <p>I tried the following query:</p>
  
  <pre><code>UPDATE names
  SET name='Michael', client_name='Michael', requester_name='Michael'
  WHERE name='Mic' OR client_name='Mic' OR requester_name='Mic';
  </code></pre>
  
  <p>This query makes all columns change all names to 'Michael'.<br>
  What should the query look like to only apply changes where applicable?</p>