Top Poster
#1 ramon fincken 253
#2 Site admin 3
#3 Ber|Art 2
#4 braddmark 1
#5 accentmedia 1
#6 Xarzu 1
#7 Jan 0
#8 roger beckers 0
#9 Christine 0
#10 nextstep 0
Replacing text in a table



Rating : 3 / 5

Tags:

 
Post new topic   Reply to topic    Ramonfincken.com Forum Index -> Mysql databases
Beta
Want to be notified by email when this topic gets a reply?  
:: View next topic  
Author Message
ramon fincken
Site's programmer

Get a free globally recognized avatar
It's free!

Joined: 03 Aug 2007
Posts: 253
Location: A'dam/Diemen, The Netherlands
PostPosted: Mon Nov 19, 2007 9:02 pm    Post subject: Replacing text in a table Reply with quote
Just got a server or domain transfer and need to update ALL links on that old IP or domain at once ?

Here's a solution , I take the example of a phpbb forum.

SQL statement to run:
Code:
update phpbb_posts_text set post_text = replace(post_text, 'old_domain.com', 'new_domain.net')


Make sure the phpbb_ prefix is the prefix you use on your boards tables

I've tested this sql statement on a mysql mysiam database and worked perfectly !
Back to top
View user's profile Send private message Visit poster's website
Google adsense
Advertisement
PostPosted: Mon Nov 19, 2007 9:02 pm    Post subject: Replacing text in a table
Advertisement
Back to top
Post new topic   Reply to topic    Ramonfincken.com Forum Index -> Mysql databases All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
General forums
The world of freelance
Programming
Other projects
Poll
I love gifts

Yes goodies and presents! [2]
No but I love polls ! [0]
Related google ads
Where am I?
Hit me!