Changing the Location path of images in solutions

Hello,

I would link to know the MSSQL 2008 query to change the path of images in solutions as the server has been changed twice and the mojority of images no longer work.

Here are 2 examples of the path that needs changing

http://tlsopman:8080/inlineimages/WorkOrder/1842/0.jpg
http://pfservdesk01:8080/inlineimages/workorder/1842/3.jpg

There are 2 parts of the path that I need updated.

I need to change the "host name" to "newserver:8080" and "workorder" to "WorkOrder".

I have tried using the following to change the workorder but although MSSQL 2008 tells me x rows are affected nothing seems to change.

Please help.