Collections:
SUBSTRING() - Substring at Given Position
How to extract a substring from a string at a given position using the SUBSTRING() functions?
✍: FYIcenter.com
SUBSTRING(str, pos, len) is a MySQL built-in function that returns a substring from a string starting at a given position for a given length. For example:
SET @str = 'dba.FYIcenter.com'; SELECT SUBSTRING(@str, 5, 9); -- +-----------------------+ -- | SUBSTRING(@str, 5, 9) | -- +-----------------------+ -- | FYIcenter | -- +-----------------------+
Reference information of the SUBSTRING() function:
SUBSTRING(str, pos, len): substr Return a substring len characters long from string str, starting at position pos. It returns NULL if any of its arguments are NULL. Arguments, return value and availability: str: Required. The string that will be extracted from. pos: Required. The starting position of the substring to extract. len: Optional. The length of the substring to extract. substr: Return value. The substring extracted. Available since MySQL 4.0.
Related MySQL functions:
⇒ SUBSTRING_INDEX() - Substring in Delimited String
⇐ SUBSTR() - Synonym for SUBSTRING()
2023-11-13, 228🔥, 0💬
Popular Posts:
What Happens to Your Transactions When ERROR 1205 Occurred in MySQL? If your transaction receives th...
How To Format DATETIME Values to Strings with the CONVERT() Function in SQL Server Transact-SQL? SQL...
Where to find SQL Server Transact-SQL language references? You can find SQL Server Transact-SQL lang...
What Are Date and Time Functions in MySQL? MySQL offers a number of functions for date and time valu...
How To Use GO Command in "sqlcmd" in SQL Server? "sqlcmd" is a command line client application to ru...