SUBSTR or SUBSTRING or MID - MySQL String Function - With Examples

Below is the syntax of the function in the description.

SUBSTR(str,pos), SUBSTR(str FROM pos), SUBSTR(str,pos,len), SUBSTR(str FROM pos FOR len)SUBSTR() is a synonym for SUBSTRING().SUBSTRING(str,pos), SUBSTRING(str FROM pos), SUBSTRING(str,pos,len), SUBSTRING(str FROM pos FOR len)

MID(str,pos,len)MID(str,pos,len) is a synonym for SUBSTRING(str,pos,len).

Music by Pixabay