Uppercase first letter of a string with MySQL

I just searched for a MySQL clone of the ucfirst(string) PHP function which converts the first letter of a string to a capital, but couldn’t find one.
Just to save you some work – I used this:

UPDATE `table` SET
`field` = CONCAT(UPPER(LEFT(`field`, 1)), SUBSTRING(`field`, 2))

and if you want to have all other characters lowercased:

UPDATE `table` SET
`field` = CONCAT(UPPER(LEFT(`field`, 1)), LOWER(SUBSTRING(`field`, 2)))

Tags:

This entry was posted on August 15th, 2008 and is filed under Development. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response or Trackback from your own site.

 
«
»
 
 

5 Responses to “Uppercase first letter of a string with MySQL”

  1. Gravatar of Alexey Alexey
    21. August 2008 at 16:19

    Great query !
    Very helpful, thanks !!!

  2. Gravatar of » Blog traffic in 2008 – internet development – strictlyPHP » Blog traffic in 2008 - internet development - strictlyPHP
    6. January 2009 at 15:37

    [...] interesting to see the different implications each post had. For instance, one of the first about uppercasing the first letter of a MySQL result value, has brought 313 visitors to this site (through almost as many search phrases) while the one about [...]

  3. Gravatar of Marc Marc
    9. March 2009 at 23:16

    Very helpful query! I couldn’t get another query like this to work, but this one worked perfectly!

    Thanks

  4. Gravatar of Debashis Mandal Debashis Mandal
    17. March 2009 at 12:03

    Great!! It worked :)

    Thank you so much!!

  5. Gravatar of Tonterias Tonterias
    12. July 2009 at 20:20

    Without any experience in database and many questions were uppercase on my list for two years.

    Thanks for your help on the Internet.

Leave a Reply