SUBSTR
A synonym for SUBSTRING: returns a substring from the given position.
MySQL 8.4
SUBSTR(str, pos[, len])- [ ]optional part
- str
- Source stringVARCHAR
- pos
- Start position, counting from 1; a negative one counts from the end of the stringINT
- len
- Length of the substring, up to the end of the string by defaultINTOptional
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.4
SELECT SUBSTR('sql-academy', 5, 3);Email with a hidden middle
MySQL 8.4
SELECT name,
CONCAT(SUBSTR(email, 1, 2), '****', SUBSTR(email, -4)) AS masked_email
FROM Users
LIMIT 5;