How to replace internal links in the database with https?

Question

Laravel

There is a table with several thousand records (publications). It is necessary to check if there are links (internal) through in the body of the publication httpand replace this httpone with https.
I made a console command that gets all the id of publications and in a cycle foreachthrough the regular expression (I used AR) replaces the necessary one, after which I save the record.
Can it be done smarter?

Answer 1

Well, at least do not use AR - this task is much easier to solve with a simple sql query - select the id and the text in which you want to replace.

Answer 2

If you are careful and with a backup, you can use the MySQL REPLACE function:
https://stackoverflow.com/questions/5956993/mysql-...
https://dev.mysql.com/doc/refman/5.7/en/string- fun...
PS It won't work with WordPress, it has its own crutches!

Answer 3

A small offtopic: It is advisable not to replace it with ` https://`, but simply replace all occurrences of ` http://` with `//`