title: How to update the same column for multiple rows in DB2
body: <p>I need to update all the records in the <code>Client</code> table if <code>address_1</code> is blank, but <code>address_2</code> is not. In those cases I want to move <code>address_2</code> into <code>address_1</code>. Here is my query so far:</p>
  
  <pre><code>UPDATE Client SET Address_1 = 'address1', address_2 = ''
  WHERE client_id = 'client_id'
  </code></pre>
  
  <p>But instead of passing in <code>client_id</code>, I want to update every record.</p>