mysql: change var to varchar

[Anon]

Hey guys,

I right now i have my database setup with a colum eg "example char(50)" how do i change it to "example varchar(50)"?

thanks,

Ben

[Anon]

alter table tablename modify example varchar(50)