• ⌂ Text
• Functions
  • CHAR_LENGTH()
  • CONCAT()
  • ENUM()
  • FIND_ALL_IN_SET()
  • FIND_ANY_IN_SET()
  • FIND_IN_SET()
  • INSTR()
  • LEFT()
  • LENGTH()
  • LOCATE()
  • LOWER()
  • LPAD()
  • LTRIM()
  • MATCHES()
  • ORD()
  • REVERSE()
  • RIGHT()
  • RPAD()
  • RTRIM()
  • SUBSTR()
  • SUBSTRING()
  • TRIM()
  • UPPER()

LOWER()

Returns a string in all lowercase.

Prototype

int LOWER(string str)

Parameters

• str - The string or expression to evaluate to a string and convert to lowercase.

Return

Returns the string str with all characters changed to lowercase according to the current character set mapping.  The default is utf8mb4.

Example

SELECT OID, LOWER(Username) AS LowerUsername FROM User

Related

UPPER()

• < LOCATE()
• LPAD() >