reorder columnd without losing ata code example

Example: how to move a column to different spot mysql

ALTER TABLE TableEx MODIFY COLUMN colName VARCHAR(50) AFTER colName2;