SUBSTR
A synonym for SUBSTRING: returns a substring from the given position.
MySQL 8.1
SUBSTR(str, pos[, len])Parameters
- strVARCHAR
- Source string
- posINT
- Start position of the substring, a negative one counts from the end of the string
- lenINToptional
- Length of the substring, up to the end of the string by default
Return value
A substring; an empty string if pos is 0 or greater than the string length, or len is less than 1
Examples
Three characters from position five
MySQL 8.1
SELECT SUBSTR('sql-academy', 5, 3);Email with a hidden middle
MySQL 8.1
SELECT name,
CONCAT(SUBSTR(email, 1, 2), '****', SUBSTR(email, -4)) AS masked_email
FROM Users
LIMIT 5;