Mysql: change column order

The order of columns is usually not important, but sometimes it annoys me. So, how to change it?