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:
23rd Jul 2007
UPDATE `tablename` SET `fieldname` = CONCAT(UCASE(SUBSTRING(`fieldname`,1,1)),'', LCASE(SUBSTRING(`fieldname`,2,LENGTH(`fieldname`)))) WHERE `id` = 1
Referral text link:
Leave a Reply