MySQL doesn’t have a specific string function for string capitalization. Use the following method for this purpose:
SELECT CONCAT(UPPER(SUBSTRING("test string", 1, 1)), LOWER(SUBSTRING("test string", 2)));
The result:
Test string
Subscribe to our article via RSS
- How to get a list of recently changed files in Linux
- How to deny access to file or directory from http (Apache webserver)
- Openfire: issues with search plugin – nothing found
- How to resolve an issue with installing google-talkplugin in Debian/Ubuntu Linux
- PGP key selection button is not available in Psi
- How to run Debian Icedove profile manager
- How to remove passphrase from the OpenSSL key
- How to disable extensions on Firefox/Iceweasel startup
- How to force recompile VMware Workstation kernel modules
- How to resolve an issue running Google Earth under Linux: googleearth-bin: No such file or directory
- rakesh in How to resolve an error: kernel pan…
- pbanerjee in How to enable bluetooth on Toshiba …
- Fernando in How to avoid error while installing…
- Backtogeek in How to install Darwin Streaming Ser…
- alexxoid in How to enable bluetooth on Toshiba …
- sheena in How to enable bluetooth on Toshiba …
- Hamish in How to add timezones to MySQL
- Android Develop… in How to enable bluetooth on Toshiba …
- Setup Korean fo… in How to setup Korean fonts in Debian…
- pgl in How to install khtml2png
- How to enable bluetooth on Toshiba Satellite A300 laptop (18)
- How to resolve an issue "Network is unreachable" in Java applications (5)
- How to install khtml2png (5)
- How to factory reset T-Mobile G1 (4)
- How to resolve an error: kernel panic - not syncing: Attempted to kill init (3)
- Stardict startup error (2)
- cURL error: asn1 encoding routines:ASN1_item_verify:unknown message digest algorithm (2)
- How to remove   entities from TinyMCE output string (2)
- How to add a wildcards for subdomains using cPanel way (2)
- How to setup Russian keyboard layout on your Android G1 mobile (2)
Search
Categories
Archives
-
- June 2011
- April 2011
- December 2010
- October 2010
- September 2010
- August 2010
- July 2010
- June 2010
- May 2010
- April 2010
- March 2010
- January 2010
- December 2009
- November 2009
- October 2009
- September 2009
- August 2009
- July 2009
- June 2009
- May 2009
- April 2009
- March 2009
- February 2009
- January 2009
- December 2008
- November 2008
- August 2008
- July 2008
Be The First To Comment
Related Post
Please Leave Your Comments Below