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>

HTH
Ignatius
_________________________
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: "PHP DB list" <[EMAIL PROTECTED]>
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 (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to