Hi,
I am searching for a MySQL command that will enable me to lower the String str to lower case automatically for the string. is it possible to lower the case of the string with the help of a command or script?
Thanks in advance.
giorgos
Hi,
I am searching for a MySQL command that will enable me to lower the String str to lower case automatically for the string. is it possible to lower the case of the string with the help of a command or script?
Thanks in advance.
giorgos
You need to learn the string functions.
LOWER(str): To lowercase
Hope this helps you.Code:mysql> mysql> SELECT LOWER('ABC'); +--------------+ | LOWER('ABC') | +--------------+ | abc | +--------------+ 1 row in set (0.00 sec)
LOWER(str)
The LOWER(str) function return the String str. And in this String all the characters are changed in the lowercase.
Code:mysql> SELECT LOWER('INDIA'); ->'india'
For complete list of String Functions please vist.
1. http://www.roseindia.net/mysql/mysql...function.shtml
and
2. http://dev.mysql.com/doc/refman/5.0/...functions.html
I hope this helps you.
Bookmarks