419Separate a column value into 2

419REVERSE(str) mysql function

419RIGHT(str,len) mysql function

418SUBSTRING mysql function

417Mysql order by values within I

417 LOWER(str) mysql function