Searching for URLs over database

Question

Searching for URLs over database

Armin May '16

Created May '16	Last Reply May '16	Replies 2	Views 268	Votes 0

Armin 23.6k

May '16

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.

badluck81
6.0k

Accepted
answer

May '16

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

Armin · Answer 1 · 2016-05-04T02:42:10-07:00

REGEXP is the magic keyword. https://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...

Nikolay Mihaylov · Answer 2 · 2016-05-04T02:54:37-07:00

Other scenarios would be:

to dump the whole database and parse/search with php inside the file;
use phpmyadmin search function
use this lib: https://code.google.com/archive/p/anywhereindb/
browse some of the answers here