How do I add a column only if it doesn't exist?

[Daevid Vincent]

I want to do something like this:

if not exists `hotel_page_templates`.`hpt_custom_fields`
alter table `hotel_page_templates` add column `hpt_custom_fields` text after
`hpt_alternate_username`;


ÐÆ5ÏÐ