SQL提取URL数据的域名(实战篇)

案例

https://www.baidu.com/s?ie=UTF-8&wd=123 > www.baidu.com

http://www.baidu.com/s?ie=UTF-8&wd=123 > www.baidu.com

相关SQL

select SUBSTR((REPLACE(REPLACE('https://www.baidu.com/s?ie=UTF-8&wd=123','https://',''),'http://','')), 1, INSTR((REPLACE(REPLACE('https://www.baidu.com/s?ie=UTF-8&wd=123','https://',''),'http://','')),'/')-1)