One possible reason you did not google back anything is that what you are
asking can't be done in SQL.
In SQL you can update only one table at a time.

Why not write a PHP function that does the job successively on each table?

To list tables in MySQL: SHOW TABLES FROM <database name>

----- Original Message -----
Sent: Thursday, November 27, 2003 15:31
Subject: [PHP-DB] Updating multilple tables?

> I have scattered around about 100 tables a block of text...
> I wasn to serach through ALL my tables, and ALL my rows for this text, adn
> repalce it with another block of text.
> I've searched n google for "mysql multiple table update" But have yet to
> find an answer..
> anyone know an easy way to do this?
> All the tables are on the same database, so I just need to say, search ALL
> tables within database
> Tris...?
> *********************************************************************
> The information contained in this e-mail message is intended only for
> the personal and confidential use of the recipient(s) named above.
> If the reader of this message is not the intended recipient or an agent
> responsible for delivering it to the intended recipient, you are hereby
> notified that you have received this document in error and that any
> review, dissemination, distribution, or copying of this message is
> strictly prohibited. If you have received this communication in error,
> please notify us immediately by e-mail, and delete the original message.
> ***********************************************************************

PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to