418Separate a column value into 2

417SUBSTRING mysql function

416REVERSE(str) mysql function

415Mysql order by values within I

415RIGHT(str,len) mysql function

414 LOWER(str) mysql function