Update part of a URL to another URL in MySQL

guest · 02-15-2009, 11:05 AM

Hi there,
I'd ask this in the mysql forums, but they're not as helpful

Here's my situation.. I have about 5k of data i need to update.. this in my current database:
http://www.siteA.com/images/picture.jpg

I want to change it to this:

http://www.siteB.com/product/images/picture.jpg

So basically, I want to change only part of the URL, not the entire URL.. is there a way to do this?

so only this part of the first url:
http://www.siteA.com/

to

http://www.siteB.com/product/

thanks!!

jschiwal · 02-15-2009, 11:37 AM

Enter "HELP REPLACE;" in mysql.
The example uses a URL.

guest · 02-15-2009, 09:02 PM

hahha nice! thanks you