MID
PostgreSQL equivalent:
A synonym for SUBSTRING: returns a substring from the given position.
MySQL 8.1
MID(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 MID('sql-academy', 5, 3) AS part;Last name after the space
MySQL 8.1
SELECT member_name,
MID(member_name, LOCATE(' ', member_name) + 1) AS last_name
FROM FamilyMembers;