Collections:
LEFT() - First N Characters
How to return first N characters from a given string using the LEFT() function?
✍: FYIcenter.com
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, 225🔥, 0💬
Popular Posts:
How to execute statements under given conditions in SQL Server Transact-SQL? How to use IF ... ELSE ...
How To Drop an Index in Oracle? If you don't need an existing index any more, you should delete it w...
How To Create a Table Index in Oracle? If you have a table with a lots of rows, and you know that on...
How To Insert New Line Characters into Strings in SQL Server Transact-SQL? If you want to break a st...
How To Find Out What Privileges a User Currently Has in Oracle? Privileges granted to users are list...