MySQL string case-sensitive conversion function

MySQL string case-sensitivity conversion requires the MySQL string case-sensitivity conversion function. MySQL string case-sensitivity conversion functions include lower (), uppper (), lcase (), and ucase ():

MySQL string case-sensitivity conversion requires the MySQL string case-sensitivity conversion function. MySQL string case-sensitivity conversion functions include lower (), uppper (), lcase (), and ucase ():

The code is as follows:

> Lower ('ddd '); + -------------- + | Lower ('ddd ') | + -------------- + | Ddd | + -------------- + Mysql> select upper ('ddd '); + -------------- + | Upper ('ddd ') | + -------------- + | DDD | + -------------- + Mysql> select lcase ('ddd '); + -------------- + | Lcase ('ddd ') | + -------------- + | Ddd | + -------------- + Mysql> select ucase ('ddd '); + -------------- + | Ucase ('ddd ') | + -------------- + | DDD | + -------------- +

In general, I select lower () and upper () to convert string case in MySQL, because this is compatible with other functions.