oke, controlla la funzione SUBSTRING

http://dev.mysql.com/doc/mysql/en/String_functions.html