Could I use the following code to alter all of my tables with a prefix of wp_ and convert them to UTF8?

ALTER wp_(what's the wildcard symbol that goes here?) CHARACTER SET utf8;

What would be the correct code to convert all tables with the prefix wp_ to the correct character set and collate values? (and how would I alter collate values as well?

I am using MySQL Version 4.0

Thanks!