418Separate a column value into 2

418SUBSTRING mysql function

417REVERSE(str) mysql function

417RIGHT(str,len) mysql function

416Mysql order by values within I

416 LOWER(str) mysql function