MYSQL MID() , LEFT() , RIGHT() , SUBSTRING(), SUBSTR()

LEFT (string, length)
RIGHT (string, length)
MID (string, position, length)
SUBSTRING (string, position, length)
SUBSTR (string, position, length)

SELECT LEFT('foobarbar', 5);
-> fooba

SELECT RIGHT('foobarbar', 4);
-> rbar


SELECT SUBSTRING('Quadratically',5);
-> ratically

SELECT SUBSTRING('foobarbar' FROM 4);
-> barbar

SELECT SUBSTRING('Quadratically',5,6);
-> ratica

SELECT SUBSTRING('Sakila', -3);
-> ila

SELECT SUBSTRING('Sakila', -5, 3);
-> aki

SELECT SUBSTRING('Sakila' FROM -4 FOR 2);
-> ki