General MySQL Oracle SQL Server

LEFT() - First N Characters

Q

How to return first N characters from a given string using the LEFT() function?

✍: FYIcenter.com

A

LEFT(str, len) is a MySQL built-in function that returns the first N characters of a giving string. For example: 

SELECT LEFT('dba.FYIcenter.com', 3);
  -- +------------------------------+
  -- | LEFT('dba.FYIcenter.com', 3) |
  -- +------------------------------+
  -- | dba                          |
  -- +------------------------------+

Reference information of the LEFT() function: 

LEFT(str, len): substr
  Returns the leftmost len characters from the string str, or NULL
  if any argument is NULL.

Arguments, return value and availability:
  str: Required. The given string to be extracted from.
  len: Required. The number of characters of the substring.
  substr: Return value. The substring of first len characters.
  Available since MySQL 4.0.

Related MySQL functions:

 

⇒ LENGTH() - Number of Bytes in String

⇐ LCASE() - Synonym for LOWER()

⇑ MySQL Functions on Character String Values

⇑⇑ MySQL Function References

2023-11-12, 1071🔥, 0💬

General MySQL Oracle SQL Server