Rearrange table columns order

MODIFY [column] column_definition [FIRST ¦ AFTER col_name]
ALTER TABLE tableName MODIFY COLUMN originalColName int(4) AFTER destinationColName