Fastest way to edit database content?

[t.bo]

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

[Barand]

UPDATE tablename SET colname = 'newval' WHERE colname = 'oldval'

[Barand]

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]