Change multiple columns in one expression

Question

I use a query to change the encoding of a column

ALTER TABLE `media_value_report` CHANGE `index_page_body` `index_page_body` TEXT CHARACTER SET utf8 NULL DEFAULT NULL 

I want to do this for other columns main_title, landing_page_body. But I get error # 1064 at runtime. Can I change multiple columns in a single query?

I tried, but found in a goog search that could not be changed in a single request.

Answer 1

In the documentation, you can bind alter_specifications with a comma:

 ALTER TABLE `media_value_report` CHANGE col1_old col1_new varchar(10), CHANGE col1_old col1_new varchar(10), ...