lower

description

Syntax

INT lower(VARCHAR str)

将参数中所有的字符串都转换成小写

example

  1. mysql> SELECT lower("AbC123");
  2. +-----------------+
  3. | lower('AbC123') |
  4. +-----------------+
  5. | abc123 |
  6. +-----------------+

keyword LOWER