How to use the LOWER () function in MySQL

Editor to share with you how to use the LOWER () function in MySQL, I believe most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!

LOWER ()

The LOWER (str) and LCASE (str) functions are used to convert a string to lowercase, for example:

SELECT LOWER ('MySQL string function') AS str1, LCASE ('MySQL string function') AS str2;str1 | str2 |-+-+ mysql string function | mysql string function |

The MySQL case conversion function does not support binary strings (BINARY, VARBINARY, BLOB), which can be converted to non-binary strings before processing. For example:

SELECT LOWER (BINARY 'MySQL string function') AS str1, LOWER (CONVERT (BINARY 'MySQL string function' USING utf8mb4)) AS str2;str1 | str2 |-+-+ MySQL string function, ²å æ °| mysql string function | the above is all about the article "how to use the LOWER () function in MySQL". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!