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

LENGTH()

Returns the number of bytes in a string or blob.  Multibyte characters count as multiple bytes.

Prototype

int LENGTH(string str)

Parameters

• str - String, blob or expression to evaluate to a string or blog.

Return

Number of bytes in the string or blob.

Example

SELECT OID, LENGTH(Username) AS UsernameLength FROM User

Related

CHAR_LENGTH()

• < LEFT()
• LOCATE() >