Sql query to rename table?

Question

MySQL

In general, it is necessary to change the link from http to https in all cells. I used to download the database, open it in the sublime, do replace all, and upload it back. But now on the phone.
In general throw sql pls.

Answer 1

UPDATE table SET url = REPLACE(url, 'http://', 'https://')

If in the entire table and in all fields, then something like this:

select concat(
       'UPDATE table_name SET ',
       column_name,
       ' = REPLACE(', column_name, ', ''http://'', ''https://'');')
from information_schema.columns
where table_name = 'my_table';