SUBSTRING — MySQL Function Reference

SUBSTRING

Returns a substring starting at the specified position [and having a specified length]

MySQL 8.1

SUBSTRING(str, pos [,len])

str

Source string

pos

The position at which the substring will start

len

Optional. The length of the received substring

If the third parameter len is not specified, then the substring is returned from position pos to the end of str.

Examples

MySQL 8.1

SELECT SUBSTRING('sql-academy', 5);

MySQL 8.1

SELECT SUBSTRING('sql-academy', 1, 3);