Unfortunately, we cannot provide you with the query. As Den said, it's not so easy converting URLs to new ones and it requires a complicated script that should parse the newsfeed data, find the URLs and change them to new URLs.
 
However, we've considered this issue and found out that this is a problem that should be solved. We should not store the definite URLs, we should insert variables, so if the URL has been changed it wouldn't affect the newsfeed functionality.
 
Sorry to say, but for now there are no easy ways to change the URLs in the static newsfeed content.

Quote from Daisy Unfortunately, we cannot provide you with the query. As Den said, it's not so easy converting URLs to new ones and it requires a complicated script that should parse the newsfeed data, find the URLs and change them to new URLs.
 
However, we've considered this issue and found out that this is a problem that should be solved. We should not store the definite URLs, we should insert variables, so if the URL has been changed it wouldn't affect the newsfeed functionality.
 
Sorry to say, but for now there are no easy ways to change the URLs in the static newsfeed content.

for newsfeed
goto phpmyadmin>go to database>part sql
Enter the code below

UPDATE ow_newsfeed_action SET data = replace(data,"url old","url new")

for blog

goto phpmyadmin>go to database>part sql
Enter the code below

UPDATE ow_blogs_post SET post = replace(post,"url old","url new")

Alireza, here is the example of the newsfeed action data:

 {"string":{"key":"friends+newsfeed_action_string","vars":{"user_url":"http:\/\/10.0.0.4\/user\/qwe","name":"Admin","requester_url":"http:\/\/10.0.0.4\/user\/grey","requester_name":"grey"}},"actionDto":null}

To replace the URL: "http:\/\/10.0.0.4\/user\/qwe" - you need to parse this data to detect which of the attributes is the URL and how to replace this with the new one. Therefore it's not so easy as you described. You need to write a script which will parse the newsfeed data, find the URLs and change them to new URLs.

What about this: Export the whole DB into an sql dump. Then just replace all strings <old domain> with <new domain>, create your DB new and import the changed sql dump?