Solved thread

This post is marked as solved. If you think the information contained on this thread must be part of the official documentation, please contribute submitting a pull request to its repository.

Searching for URLs over database

Hello,

I have to pull all external links from my database and save it somewhere (ex. new database or txt file). What is the best solution for searching url links trought whole database and exporting them. I have around 100 tables so I dont want to that manualy.



9.3k

REGEXP is the magic keyword. http://stackoverflow.com/questions/9033018/regexp-to-validate-url-in-mysql

Thats it friend. Now I have to find a way to preform it on all database not specific tables...

Other scenarios would be: