SQL Update Replace part of text from a string

Question

I'm using MS Access and I have a table called Backup and a column named ImageURL. The ImageURL column has data such as: http://domain.com/s/1234.jpg.

I want to change the /s/ in the URL intoto /l/ by using an MS Access SQL Update and Replace.

When I'm trying it at the moment, it's replacing the entire field to /l/.

Thanks for your help!

Rob

@paxdiablo The link was used as an example and wasn't meant to be a valid location. All of the pertinent information is included in the question which is why there was a good answer immediately. — phrebh
– phrebh, Commented Jul 1, 2016 at 15:10
Apologies, I read that as a real link rather than data from the DB table. I've backticked it so it doesn't show up as a hyperlink. — paxdiablo
– paxdiablo, Commented Jul 7, 2016 at 1:31

Madhivanan · Accepted Answer · 2012-07-17 09:00:02Z

9

Update Backup
set ImageURL =replace(ImageURL,'/s/','/I/')

answered Jul 17, 2012 at 9:00

Madhivanan

13.7k1 gold badge28 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SQL Update Replace part of text from a string

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related