Outdated Version
You are viewing an older version of this section. View current production version.
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
memsql> select substring('1234567890', 3, 3);
+-------------------------------+
| substring('1234567890', 3, 3) |
+-------------------------------+
| 345 |
+-------------------------------+
memsql> select substring('1234567890', -3, 3);
+--------------------------------+
| substring('1234567890', -3, 3) |
+--------------------------------+
| 890 |
+--------------------------------+
1 row in set (0.68 sec)
Related Topics