CODE EXAMPLE FOR SQL

how to move a column to different spot mysql

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