SELECT CONCAT( SUBSTR(col, LOCATE(' ', col)+1), ' ', SUBSTRING_INDEX(col, ' ', 1) ) FROM table;