MySQL : Make First Letter Uppercase



This MySQL Snippet will make the first letter of any text into uppercase. This may come in handy in your future work and might as well worthy of sharing.

UPDATE test1 SET test_char = CONCAT(UCASE(LEFT(test_char, 1)), SUBSTRING(test_char, 2));

Labels: ,