UPDATE `categories` SET category_name = CONCAT(UCASE(SUBSTRING(`category_name`, 1,1)),LOWER(SUBSTRING(`category_name`, 2)))
Thursday, September 16, 2010
Capitalize the first letter of a sentence with MYSQL
Subscribe to:
Post Comments (Atom)
UPDATE `categories` SET category_name = CONCAT(UCASE(SUBSTRING(`category_name`, 1,1)),LOWER(SUBSTRING(`category_name`, 2)))
No comments:
Post a Comment