Can test the sql statement by using a select instead of an update, verify the results, then when satisfied can change it to an update query.
SELECT replace(products_description, 'http://website.com', '//website.com') from products_description;
I think is the appropriate sql for the select. Untested.
Bookmarks