MySQL Capitalise strings
posted on 9th Aug, 2009 in MySQLSimple mysql query to capitalise strings
SELECT CONCAT( UCASE(LEFT(TRIM('MYSTRING'), 1)) , LCASE(SUBSTRING(TRIM('MYSTRING'), 2)) );
Bookmark with
About
Welcome to my online portfolio and development site where i can share my developments and projects.
Ive been developing for 7 years working mainly with online applications and websites.
Download my CV orCategories
Favorites
- Design Inspiration - faveup.com
- Free Hosting - zymic.com
- Iamandy - iam-andy.co.uk
- MooTools - mootools.net
- PSDTUTS - psdtuts.com
- ThemeForest - Templates, WordPress Themes
Subscribe
