mySQL UCFIRST Capitalize the first letter of each word using MYSQL

for mySQL UCFIRST we need to do the following steps

1. Divide the string into two segments using mysql function SUBSTRING.
2. First part will be the single letter which we will converting that to upper case using mysql function UCASE. To acheive this we will use UCASE(SUBSTRING(‘column_name’, 1,1)).
3. Second part will be the remaining letters. We will convert these letter to lower case mysql function LOWER. To acheive this we will use LOWER(SUBSTRING(‘column_name’, 2)).
4. Then we will contact both the parts using mysql function CONCAT.

mysql ucfirst example query:

UPDATE ‘table’  SET source_field = CONCAT(UCASE(SUBSTRING(‘column_name’, 1,
1)),LOWER(SUBSTRING(‘column_name’, 2)))