In MySQL:
UPDATE mytable
SET    mycol = REPLACE( mycol, $replacee, $replaceor )

All you have to do is provide the loop some structure so that it can find
the column to process
eg an array( "table" => array( "column1", ... ) ) or even better another
table.

Ignatius
_________________________
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: "Ignatius Reilly" <[EMAIL PROTECTED]>
Cc: "PHP DB list" <[EMAIL PROTECTED]>
Sent: Thursday, November 27, 2003 16:02
Subject: Re: [PHP-DB] Updating multilple tables?


> All good,
> I've got a loop based on all my tables... (cheers for that)
> however, I still wanna look within an entry for a smaller entry..
>
> EG:
> "the quick brown frog jumped over the lazy dog"
> I want to find and repace "frog" with "fox" but do this happens with text
> all over my database.
>
> I'll get there...! ;-)
>
>
>
>
>
>
>
> "Ignatius Reilly" <[EMAIL PROTECTED]>
> 27/11/2003 15:02
>
> To
> "PHP DB list" <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>
> cc
>
> Subject
> Re: [PHP-DB] Updating multilple tables?
>
>
>
>
>
>
> 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
>
>
>
>
> *********************************************************************
> 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