Noob question - phpadmin search and replace sql query - Please HELP

[jackpotsoftware]

I just have a noob question. My coder is MIA and I have an issue to fix that could cost me a lot of time doing it manually.

Basically, I have a database with a unique identifier (blog_id), a set of 100 posts with the same user id (user_id) and I need to replace a link in the set of 100 posts with that user id. The link i need to replace is in the (content) column.

Basically, i need the query to SELECT the user_ID i have, and REPLACE the link in the (CONTENT) column that has that link that I want to change to the New link (I have both the new link and old link)

If someone could help me, I'd greatly appreciate it. I just need the right Sql query.

[Gowri]

Don know if i am correct over here i would advise you to check the following code

UPDATE wp_posts1 SET post_content1 = REPLACE (post_content1, 'old link', 'new link');