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()
2023-11-12, 1905🔥, 0💬
Related Topics:
