Jump to content

Archived

This topic is now archived and is closed to further replies.

t.bo

Fastest way to edit database content?

Recommended Posts

Hello everybody,

I have a lot of text and links set in my database. Now i've seen that there's an error in all the links and all the same error. I need to edit them but if im gonna edit every link seperatly its gonna take me a lot of time.

How can i edit database content really fast. I need something like the Find and replace function in dreamweaver.

Could I enter phpmyadmin and use update tablename SET ...    ?
The links are not in a separate field but together with text in one big content field.
Greetz and thanks in advance

Share this post


Link to post
Share on other sites
UPDATE tablename SET colname = 'newval' WHERE colname = 'oldval'

Share this post


Link to post
Share on other sites
If you just want to change part of a column's value,
[code]
$srch = 'my.domain.com';
$rplc = 'your.domain.com';
$sql = "UPDATE tablename SET colname = REPLACE(colname, '$srch', '$rplc')"; [/code]

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.