417Separate a column value into 2

416SUBSTRING mysql function

414RIGHT(str,len) mysql function

413 LOWER(str) mysql function

413REVERSE(str) mysql function

412Mysql order by values within I