I want to change all my downloadable product from link_file to url_file, so I created a query for that. Can I get advice if this query is safe for me to run.

UPDATE downloadable_link SET link_url = CONCAT('http://www.mywebsite.info/download/',(substring_index(link_file, '/', -1)) ) , link_file =NULL , link_type = 'url' WHERE link_id >=0 AND link_id<=1000;



Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.