Sql script to delete section of text?
Posted: Mon May 25, 2009 10:33 am
Hi everyone
I am hoping someone could help. My website uses a database which via a feed from an external database (which I do not have access to) updates every day and includes image URLS.
The problem I have is the feed inputs the image url like
What I need to be able to run is a SQl script that gets rid of the word images before the picture name. In the example above the result would be
I have looked at UPDATE statements but haven't been able to figure out a way of truncating just that part of the URL.
If anyone could help that would be jolly marvellous!
Regards
peter
I am hoping someone could help. My website uses a database which via a feed from an external database (which I do not have access to) updates every day and includes image URLS.
The problem I have is the feed inputs the image url like
Code: Select all
http://www.mysite.com/images/imagespicture1.jpgCode: Select all
http://www.mysite.com/images/picture1.jpgIf anyone could help that would be jolly marvellous!
Regards
peter