Thread:Project:Support desk/editing a lot of similar external links inside MediaWiki (Database)/reply

You can use special:linksearch to get a list of external links.

The page text may be gzipped or something like that in db (but i didn't think it was by default) which might be why you're not picking those up in a regex. Additionally doing regex on a db dump like that will cause db inconsitency (in your case only in the externallinks table, along with the rev_sha1 and ar_sha1 fields of the revision and archive table. Possibly not the end of the world, but not exactly a great idea either).

I would reccommend trying w:Wikipedia:AutoWikiBrowser or Pywikipediabot to fix the links.