ramon fincken
Site's programmer
Joined: 03 Aug 2007
Posts: 65
Location: Amsterdam, the Netherlands/Europe
|
 Posted: Mon Nov 19, 2007 9:02 pm Post subject: Replacing text in a table |
 |
|
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 ! |
|
