Convert to sentence case in MySQL

We're offering a special website development package for small businesses in Australia. Contact us today to find out more.

23 Jul, 2007

Web Development » Snippets » Convert to sentence case in MySQL

UPDATE `tablename`
SET `fieldname` =  CONCAT(UCASE(SUBSTRING(`fieldname`,1,1)),'', 
LCASE(SUBSTRING(`fieldname`,2,LENGTH(`fieldname`))))
WHERE `id` = 1

Other similiar posts that you might be interested in:

No Responses to "Convert to sentence case in MySQL"

Comment Form

7 Days Traffic Building Exercise - Web Development Blog: [...] – Day 2 7 Days Traffic Building Exercise – Day 3 7 Days Traffic Building Exercise – Day 4 7 Days Traffic Building Exercise – Day 5 7 Day
7 Days Traffic Building Exercise - Web Development Blog: [...] Days Traffic Building Exercise – Day 1 7 Days Traffic Building Exercise – Day 2 7 Days Traffic Building Exercise – Day 3 7 Days Traffic Bu
7 Days Traffic Building Exercise - Web Development Blog: [...] 7 Days Traffic Building Exercise – Day 1 7 Days Traffic Building Exercise – Day 2 7 Days Traffic Building Exercise – Day 3 7 Days Traffic

Interests

Web development, Web design, Open source technologies, Portal development, APIs, Web services, Social media applications, Search engine optimisation, Mobile application development, iPhone Apps, Web 2.0, Web 3.0, Latest Internet technologies