CHANGING COLUMN NAME IN MYSQL

Let's say our column is currently named coffee but you decide that drink would be a more appropriate title. This column is located on the table called menu. Here is an example of how to change it:

alter table menu change coffee drink varchar (10) ;