alter fields in mysql

[sitNsmile]

Okay for example if I have

table `games`

game_id
game_title
game_desc
game_keywords
game_added <--want to move up

===new database===

game_id
game_added <--moved
game_title
game_desc
game_keywords


How can I move a field somewhere else (with keeping the EXISTING) data in tacked.

This is rough example of what I am trying to do, but I need to know how to alter the fields in the table. any ideas?

Thanks


===RESOLVED===

Finding that this worked correctly.

"ALTER TABLE games MODIFY COLUMN dateadded int AFTER gameid"