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, 217🔥, 0💬
Popular Posts:
How To Download Oracle Database 10g XE in Oracle? If you want to download a copy of Oracle Database ...
How to set database to be READ_ONLY in SQL Server? Databases in SQL Server have two update options: ...
How AdventureWorksLT tables are related in SQL Server? There are 12 user tables defined in Adventure...
How To Query Tables and Loop through the Returning Rows in MySQL? The best way to query tables and l...
Where to find answers to frequently asked questions on INSERT, UPDATE and DELETE Statements in MySQL...