I'm trying to search and replace the "http" protocol to "https" in certain domains in my MySql DB in a "links" table that contains urls only.

I would have used the REPLACE function if I was to change ALL the urls to "https".
but because it's certain domains I have to use REGEXP:

```
SELECT long_url 
FROM links 
WHERE long_url REGEXP '^http\:\/\/(www|academic|www3)\.?domain\.com'

```

so so far I got to the searching stage.
I've looked in the documents and as of now I see no way to do the replace with the result I got from the sql query.

please note I only have access to the MySql database, I don't have PHP or anything to run anything smarter than SQL queries.