title: How to lowercase the whole string keeping the first in uppercase in MYSQL
body: <p>My Table column -</p>
  
  <p><img src="https://i.stack.imgur.com/cY09y.jpg" alt="enter image description here"></p>
  
  <p>My expected Output to change in column - </p>
  
  <pre><code>Smith, Allen, Doyle, Dennis, Baker, Waker
  </code></pre>
  
  <p>This is what i tried, but not working :( -</p>
  
  <pre><code>UPDATE TABLE `employee`
  SET last_name = UCASE(LEFT(lower(last_name), 1))
  
  UPDATE TABLE `employee`
  SET last_name = ucase(lower(last_name),1)
  </code></pre>
  
  <p>Followed this link too - <a href="https://stackoverflow.com/questions/4263272/capitalize-first-letter-mysql">Resource</a></p>
  
  <p>ERROR --</p>
  
  <pre><code>#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TABLE `employee` SET last_name = UCASE(LEFT(lower(last_name), 1))' at line 1
  </code></pre>
  
  <p>Let me know what I am doing wrong and how to fix.</p>