Watch the 7.3 Webinar On-Demand
This new release brings updates to Universal Storage, query optimization, and usability that you won’t want to miss.

SUBSTRING

Extracts a range of characters from a string.

Syntax

SUBSTRING(str, start, len)
SUBSTR(str, start, len)

Arguments

  • str: any string or binary object
  • start: the one-indexed position to start at. If negative, counts from the end.
  • len: the number of characters to extract

Return Type

String

Examples

SELECT SUBSTRING('1234567890', 3, 3);
+-------------------------------+
| SUBSTRING('1234567890', 3, 3) |
+-------------------------------+
| 345                           |
+-------------------------------+

SELECT SUBSTRING('1234567890', -3, 3);
+--------------------------------+
| SUBSTRING('1234567890', -3, 3) |
+--------------------------------+
| 890                            |
+--------------------------------+
1 row in set (0.68 sec)

Related Topics