initcap

Description

Syntax:

VARCHAR initcap(VARCHAR str)

This function capitalizes the first letter of each word and de-capitalizes the other letters. The words are sequences of alphanumeric characters separated by non-alphanumeric characters.

Example

mysql> select initcap('hello hello.,HELLO123HELlo');
+---------------------------------------+
| initcap('hello hello.,HELLO123HELlo') |
+---------------------------------------+
| Hello Hello.,Hello123hello            |
+---------------------------------------+

Keywords

INITCAP

hex instr