How to convert lowercase to uppercase in mysql database

This article mainly shows you the "mysql database how to achieve lowercase to uppercase", the content is easy to understand, clear, hope to help you solve your doubts, the following let the editor lead you to study and learn "mysql database how to achieve lowercase to uppercase" this article.

Mysql to achieve lowercase characters to uppercase methods: 1, the use of UPPER () function, syntax "SELECT UPPER (str);"; 2, the use of LOWER () function, syntax "SELECT LOWER (str);"

The operating environment of this tutorial: windows10 system, MySQL version 5.7.24, Dell G3 computer.

Prerequisite: log in to mysql

Open a command line window through the cmd command

Connect to the local database service through the built-in client command mysql of MySQL database

For related commands and operations, please refer to the illustration.

Method 1: complete the conversion from lowercase to uppercase through the built-in function UPPER

UPPER (letter string), all lowercase letters in the substring will be converted to uppercase letters, as shown.

Method 2: complete the conversion from lowercase to uppercase through the built-in function LOWER

All uppercase letters in LOWER (letter string), substring "will be converted to lowercase letters, as shown."

The above is all the contents of the article "how to convert lowercase to uppercase in mysql database". 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!