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

LEFT()

Returns the leftmost len characters from the string str, or NULL if any argument is NULL.

Prototype

string LEFT(string str, int length)

Parameters

• str - Original string to trim.
• length - Length of str to be returned from the left.

Return

Returns the leftmost len characters from the string str, or NULL if any argument is NULL.

Example

SELECT LEFT(Username, 10) AS UsernameFirstTen FROM User

Related

RIGHT()

• < INSTR()
• LENGTH() >