title: Capitalize first letter of each word, in existing table
body: <p>I have an existing table 'people_table', with a field <code>full_name</code>.  </p>
  
  <p>Many records have the 'full_name' field populated with incorrect casing.  e.g. <code>'fred Jones'</code> or <code>'fred jones'</code> or <code>'Fred jones'</code>.</p>
  
  <p>I can find these errant entries with:</p>
  
  <pre><code>SELECT * FROM people_table WHERE full_name REGEXP BINARY '^[a-z]';
  </code></pre>
  
  <p>How can I capitalize the first letter of each word found?  e.g. <code>'fred jones'</code> becomes <code>'Fred Jones'</code>.</p>