Is it possible to use UPDATE to change a stored URL?

I have a stored URL something like this:

I want to change all URLs in the database with that format to:

Is there an easier way to do this than manually changing one entry at a time?

Tried using "UPDATE articles SET url='' WHERE url=''". Doesn't work, nor does using LIKE instead of =.