title: How do I change the case on every field in a mysql table in one call?
body: <p>I have a table with 27 varchar fields. I want to make all fields lowercase, but i want to do it in one short mysql call.</p>
  
  <p>This does a single field:</p>
  
  <pre><code>UPDATE table
  SET field = LOWER(field)
  </code></pre>
  
  <p>How do I do the equivalent of this (which doesn't work):</p>
  
  <pre><code>UPDATE table
  SET * = LOWER(*)
  </code></pre>