I need to format strings like:
Code:
this string needs to be each first letter capitalized
/* to */
This String Needs To Be Each First Letter Capitalized
I had already done that
Code:
SELECT
 CONCAT(
  UPPER(SUBSTRING("string to capitalize", 1, 1)),
  LOWER(SUBSTRING("string to capitalize", 2,
   CHAR_LENGTH("string2capitalize"))
  )
 ) AS "Capitalized"



+----------------------+
| Capitalized          |
+----------------------+
| String to capitalize |
|                      |
+----------------------+
But it capitalizes only the first letter of the string