Changing links

#1
Guest_Jaan_*

Posted 25 December 2008 - 01:02 PM

Guests

Okay.. I have pretty bad problem..

I have to change over 150 links in database.. from http://localhost/wordpress
to my site's url.. Does anyone know how I can do it with PHP because I really don't wanna do it manually..
And thinking is so hard for me atm.. :D that's why I ask from you :D

#2
John

Posted 25 December 2008 - 01:54 PM

Writes binary right handed and hex left handed

Moderators
6,321 posts

You don't need to use PHP, you can just use SQL. MySQL :: MySQL 5.0 Reference Manual :: 11.4 String Functions

Compiled Thoughts

#3
Guest_Jaan_*

Posted 25 December 2008 - 05:05 PM

Guests

So.. I do like this:

[highlight="sql"]
REPLACE ("http://localhost/wordpress", "http://localhost/wordpress", "http://mysiteaddress")
[/highlight]

or something?

#4
Guest_Jaan_*

Posted 25 December 2008 - 05:27 PM

Guests

hmm.. I tried this:

$query = mysql_query("SELECT REPLACE('http://localhost/wordpress', 'http://localhost/wordpress', 'http://mysite')");
if(!$query){
	die(mysql_error());
}

But it didn't work

and I tried this in phpMyAdmin:

[highlight="sql"]
SELECT REPLACE('http://localhost/wordpress', 'http://localhost/wordpress', 'http://mysite');
[/highlight]

And it didn't work hmm :/

#5
Orjan

Posted 25 December 2008 - 05:50 PM

Writes binary right handed and hex left handed

Moderators
3,299 posts

UPDATE links set address=REPLACE(address, 'http://localhost/wordpress', 'http://mysite');

will update ALL entries in the table links within the column address having 'http://localhost/wordpress' replaced to 'http://mysite'

#6
Guest_Jaan_*

Posted 25 December 2008 - 06:10 PM

Guests

Awesome.. it works mate !
thank you very much ^^

#1 Guest_Jaan_* Posted 25 December 2008 - 01:02 PM

#2 John Posted 25 December 2008 - 01:54 PM

#3 Guest_Jaan_* Posted 25 December 2008 - 05:05 PM

#4 Guest_Jaan_* Posted 25 December 2008 - 05:27 PM

#5 Orjan Posted 25 December 2008 - 05:50 PM

#6 Guest_Jaan_* Posted 25 December 2008 - 06:10 PM