Updating parts of SQL Data

[mididelight]

Hello,

I am trying to update part of SQL data but am not getting it to work. Here is my example. I have a row that has the data "apple.mid" in a column called url. I want to change the extension of the data to "apple.zip". Is there a way to only change part of the data?

I tried this:
UPDATE dir_pages
SET url = url+'.zip'
WHERE url like '%.mid' AND id = '2'

But I am not getting the right value.

[NogDog]

If you are using MySQL, this might do the trick:

UPDATE dir_pages SET url = REPLACE(url, '.mid', '.zip')
WHERE url like '%.mid' AND id = '2';

[mididelight]

and that worked! thank you, didnt even know there was a replace function in mysql