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.

 
«
»
 
 

6 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.

  6. Gravatar of Kiran Kiran
    5. April 2010 at 16:10

    Thanks for this . It worked perfectly .

Leave a Reply