418Separate a column value into 2

417SUBSTRING mysql function

416Mysql order by values within I

416 LOWER(str) mysql function

416REVERSE(str) mysql function

416RIGHT(str,len) mysql function