Replace text with another text from a database

replace string

[aff_dan]

Hello,

I have in a TABLE wp_posts some text wrong, a web site url.

I want to change from all posts that URL from my database with another URL from my posts article.

I have not found on YAHOO any ideas about it.

Any help how to do?

Regards,
Dan

[coopster]

PHP has a str_replace() [php.net] function that may be of interest.