Re: How to Replace the table data
| From: | Jason Wong | Date: | Thu, 13 Sep 2001 21:12:59 +0000 |
| Subject: | Re: How to Replace the table data | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-12430@lists.php.net to get a copy of this message | ||
> Is it possible to find and replace a data in the table using phpMyAdmin ?
> If yes, how to do that ?
>
> I want to change "http://something.com/" to
"http://www.something.com/target"
Run an UPDATE query?
UPDATE table SET url='http://something.com/'
WHERE
url='http://www.something.com/target'
hth
--
Jason Wong
Gremlins Associates
www.gremlins.com.hk
Tel: +852-2573-5033
Fax: +852-2573-5851