Query Run
use jawiki_p; select substring_index( substring_index( el_to, '/', 3 ),... 4 years ago
use jawiki_p; select el_to, substring_index( substring_index( el_to, '/', 3... 4 years ago
use jawiki_p; select el_to, substring_index( substring_index( el_to, '/', 3... 4 years ago
use jawkki_p; select el_to, substring_index( substring_index( el_to, '/', 3... 4 years ago
use jawiki_p; select el_to, left(mid(el_to, locate('//', el_to)+2),... 4 years ago
use jawiki_p; select left(mid(el_to, locate('//', el_to)+2), locate('/',... 4 years ago
use jawiki_p; select left(mid(el_to, locate('//', el_to)-2), locate('/',... 4 years ago
use jawiki_p; select left(mid(el_to, locate('//', el_to)+2), locate('/',... 4 years ago
use jawiki_p; select left(mid(el_to, locate('//', el_to)+2), locate('/',... 4 years ago
use jawiki_p; select left(mid(el_to, locate('//', el_to)+2), 10) as... 4 years ago
use jawiki_p; select left(mid(el_to, locate('//', el_to)+2), locate('/',... 4 years ago
use jawiki_p; select left(mid(el_to, locate('//', el_to)+2), locate('/',... 4 years ago
use jawiki_p; select left(mid(el_to, locate('//', el_to)+2), locate('/',... 4 years ago
use jawiki_p; select left(mid(el_to, locate('//', el_to)+2), locate('/',... 4 years ago
use jawiki_p; select left(el_to, locate("/", el_to, 9)-1) as domain,... 4 years ago
use jawiki_p; select left(el_to, locate("/", el_to, 9)) from externallinks limit 100 4 years ago
use jawiki_p; select * from externallinks limit 100 4 years ago