To rearrange columns in MySQL you can use the following snippet.

ALTER TABLE TABLENAME MODIFY COLUMN COLUMNNAME TYPE AFTER COLUMNNAME