• ⌂ 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()

UPPER()

Returns a string in all uppercase.

Prototype

int UPPER(string str)

Parameters

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

Return

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

Example

SELECT OID, UPPER(Username) AS UpperUsername FROM User

Related

LOWER()

• < TRIM()
• Object Information >