MySQL Intercept string

MySQL string intercept
1. Intercept string from left
Left (str,length) truncated field, intercept length
Select Left (' admin1213 ', 5) from table

2, starting from the right to intercept the string
Right (str,length) truncated field, intercept length
Select Right (' admin1213 ', 5) from table
3. Intercepting strings
SUBSTRING (str,pos) intercepted field, from the first intercept
Select substring (' admin1213 ', 5) from table

SUBSTRING (str,pos,length) the intercepted field, from the first intercept, intercept the length
Select substring (' admin1213 ', 5,3) from table

MySQL Intercept string