Renaming a column can be done in a single statement but as well as the new name, the "column definition" (i.e. its data type and other optional properties such as nullability, auto incrementing etc.) must also be specified.
ALTER TABLE `<table name>` CHANGE `<old name>` `<new name>` <column definition>;
SHOW CREATE TABLE <table name>;(replacing
<table name>with the relevant value).
<column definition>in the line above with the relevant values and then execute it.