|
|
MySQL command to convert a string to lowercase - Mysql
|
Views : 427
|
|
Tagged in : Mysql
|
|
|
Report This Scrap as Inappropriate
We request you to choose the appropriate categroy and subcategory that suits your
objectionable concern about the scrap, So that our team can review and find out whether it violates our Guidelines or the
scrap is not suitable for all viewers.
|
MySQL command to convert a string to lowercase
In MYSQL we have a command LOWER() which help us to convert a string to lowercase.
For Example:
We have MYSQL database of keywords that are presently mixed-case. If we want to convert them all to lowercase we can use the command LOWER().
1. UPDATE table_name SET col_name=LOWER(col_name);
2. SELECT LOWER('SANJESH');
Result:
sanjesh
3. SELECT LOWER(column_name) FROM table_name;
|
|
By Sanju, On - 2010-01-13 |
|
|
|
