Update stream_source table

[Fringe]

Hey all

My SQL isn't brilliant so need some help. On my DB all my VOD films are pointing to the old XC server ID so need to change just that part to XC UI server ID. I thought this SQL query would be ok

UPDATE streams
SET stream_source = REPLACE(stream_source, 'S:39', 'S:12');

S:39 is the server ID on the old XC panel
S:12 is the new server ID on XC UI

but when i enter that query in the SQL part of phomyadmin and click 'Simulate Query' I get the following reply

SQL query:
UPDATE streams SET stream_source = REPLACE(stream_source, 'S:39', 'S:12')
Matched rows: 0

so its not making any changes, on the stream_source table films would still show as
eg,

["s:39:\/home\/FILMS\/A-E\/Aladdin (2019).avi"]

and not

["s:21:\/home\/FILMS\/A-E\/Aladdin (2019).avi"]

I must be missing something, so can anyone help?

 

[sympan]

in latest version of UI has mass edit for movies, with this can edit server for movies that you want