Web Development Blog

by Ei Sabai Nyo

Web Development » Snippets » Convert to sentence case in MySQL
23 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
Love what you've just read? Subscribe to our newsletter to receive tips, resources and special offers related to web development & design.
Your name:   Your email:  

Comments are closed.

Profile PicHello! Welcome to Web development blog! My name is Ei Sabai and on this blog, I write about web development, mobile app development, latest web technologies and the likes. Read more about me or have a look at some of the tips & resources I've written.

Search

Subscribe to our newsletter to receive tips, resources and special offers related to web development & design.
We do NOT spam.
Your name:  
Your email:  

Tips & Resources

Tips & Resources
WordPress Web Hosting
Recommended web hosting providers for WordPress 3.0
iPhone Native App Development
Important steps into iPhone app development for beginners
iPhone Web App Development
Tips for iPhone web app development
Coupons for Web Developers
Get discounts on web hosting, domain names, templates, etc
10 Useful jQuery Snippets
Easy-to-use jQuery snippets for any website
HTML Email Newsletter
Step-by-step tutorial on how to code an HTML email newsletter
More Tips & Resources
  • bluehost Hosting $6.95/month
  • Joomla Templates

Recommended Book

Categories