Droping multiple tables by a pattern in the table name

Hello, I'm using mysql 4.1.14-standard. I would like to drop multiple tables in one or few queries. I don't have an easy way to predict their names (I have a way to find their names, but it's by using software and I prefer doing it with mysql). All of the table names have a fixed part which I

Edit utf-8 tables via the client

Hello, I'm using mysql-standard-4.1.14 and mysql-client-4.1.14 on a RH9 machine, I have utf-8 tables with hebrew data. When using the client I see the hebrew as question marks. I would like to view and edit the data via the client. I've tried using a terminal that is surely able to view unicode

An existing table

Hello, Is there a way to add a column to an existing table in a mysql database? couldn't find it on the guide. Thanks. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/