Need to update a feild in MySQL database

Here is the story:
I have a phpBB fourm.

I have been moving files around on my server, images that I have embedded in some posts.

Is there a way to simply update old/url/of/file to new/url/of/file via phpMyAdmin?

I know that the path is stored in the post_text column.

thanks

 

You'll have to browse each query and change it yourself. Or export that table and do the edits locally. Then upload it onto your mySQL. That is the only way it can be done.

 

I can't just search for something and replace it within the database?

 

What about something like this that I just found

UPDATE table SET column = replace(column, 'old/url', 'new/url');

Code (markup):

 

That is what is meant by "edit it locally"

 

I am not yet getting exact requirement, but if its merely changing base path from A to B then your update query should do the trick, however before that you need to be certain of the changes and all possible combinations.

 

Yes it is just changing the path to the file, the filenames are gong to stay the same.
The problem is that these url's are within the post_text field in the database which stores the entire posts.