« 12 Coding Languages That Never Took Off
Digg - Out of service »

23rd Jul 2007

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

Referral text link:

This entry was posted on Monday, July 23rd, 2007 at 9:42 am and is filed under Snippets. 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.

Leave a Reply