91
Scripts and Templates / Re: Some usefull SQL scripts in PVD
« Last post by Ivek23 on December 22, 2023, 09:00:47 pm »Use this SQL script if you are missing this part in the imdb url: www.
Instructions on how to use the SQL script are in the first post.
Here you have some more similar SQL scripts.
Quote
update MOVIES set "url"=replace("url",'http://imdb', 'http://www.imdb');
Instructions on how to use the SQL script are in the first post.
Here you have some more similar SQL scripts.
Quote
update MOVIES set "url"=replace("url",'http://httpbin.org/response-headers?key=http://www.imdb', 'http://www.imdb');
Quote
update MOVIES set "url"=replace("url",'http://httpbin.org/response-headers?key=https://', 'http://');
Quote
update MOVIES set "url"=replace("url",'http://httpbin.org/response-headers?key=', '');