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:
SET url = url+'.zip'
WHERE url like '%.mid' AND id = '2'
But I am not getting the right value.