Web Development Blog

Twitter

23 Jul, 2007

Convert to sentence case in MySQL

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


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