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 [...]
