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, 232🔥, 0💬
Popular Posts:
How To Recover a Dropped Index in Oracle? If you have the recycle bin feature turned on, dropped ind...
How To Download Oracle Database 10g XE in Oracle? If you want to download a copy of Oracle Database ...
How To Verify Your PHP Installation in MySQL? PHP provides two execution interfaces: Command Line In...
How To Change the Password for Your Own User Account in MySQL? If you want to change the password of...
How to change the data type of an existing column with "ALTER TABLE" statements in SQL Server? Somet...