SQL downloads_files_records

[MEVi]

Hello,

I made a change in the domain so that many files I sent are identified in the wrong place, when I used to add a photo by a direct link in HTTPS how can I fix this?

SQL: downloads_files_records

sslink https:/xyz.toto.xxx changed by https:/xyz.titi.xxx

Edited February 4, 2021 by MEVi

[bfarber]

UPDATE downloads_files_records SET column=REPLACE(column, 'https://xyz.old.com', 'https://xyz.new.com');

Take a backup first, add your SQL table prefix to the table name if applicable, and adjust "column" appropriately. Also, it goes without saying, adjust the old and new URLs appropriately.