MySQL SUBSTRING() Function

❮ MySQL Functions

Example

Extract a substring from a string (start at position 5, extract 3 characters):

SELECT SUBSTRING("SQL Tutorial", 5, 3) AS ExtractString;

Try it Yourself »

---

Definition and Usage

The SUBSTRING() function extracts a substring from a string (starting at any position).

Note: The SUBSTR() and MID() functions equals to the SUBSTRING() function.

Syntax

SUBSTRING(string, start, length)

OR:

SUBSTRING(string FROM start FOR length)

Resource: https://www.w3schools.com/sql/func_mysql_substring.asp