Product Solutions Support
Try MemSQL

SUBSTRING

Extracts a range of characters from a string.

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

Arguments

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)
Was this article useful?