碰到个小问题 记录下，有用sql中的正则表达式

看看吧

select xmo_dw.url_decode(domain) as domain,substring(xmo_dw.url_decode(domain) from '^https?:\/\/(.*?)\/.*?') from xmo_dw.rtb_datas where searchengine_id in (select id from xmo_dw.searchengines where campaign_id=14039) and viewed_at_i=20151122 limit 5;