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:
- Apending text to a field which isn’t empty (mysql)
- Delete rows older than x days or x months in MySQL
- Remove the first character in mysql
- How to check if div exists in jQuery
- Find and replace text in mysql
- New-Window Links in a Standards-Compliant World
- 10 Examples of Basic Input Validation in Javascript
