Adding columns to tables in the correct place

[OriginalSunny]

Hi,
i want to add some columns to me table after other columns already exsistent in the table. I know the following command works:

alter table tablename add column columnname ... first;

This puts the column at the beginning of the table. How do i place it so its the third column in the table or so that it is after another column??
Thanks.

[shoz]

[!--sql--][div class=\'sqltop\']SQL[/div][div class=\'sqlmain\'][!--sql1--][span style=\'color:blue;font-weight:bold\']ALtER TABLE[/span] tablename ADD newcolumn ... AFTER othercolumn [!--sql2--][/div][!--sql3--]
[a href=\"http://dev.mysql.com/doc/refman/4.1/en/alter-table.html\" target=\"_blank\"]http://dev.mysql.com/doc/refman/4.1/en/alter-table.html[/a]