417Separate a column value into 2

417SUBSTRING mysql function

415REVERSE(str) mysql function

414Mysql order by values within I

414RIGHT(str,len) mysql function

413 LOWER(str) mysql function