조회 : 114
SELECT
url,mid(url,LOCATE('//',url)+2,LOCATE('/',substring(url,LOCATE('//',url)+2 ))-1)
FROM `DBT`
http_referer | mid( http_referer , LOCATE( '//' , http_referer ) + 2 , LOCATE( '/' , substring( http_referer , LOCATE( '//' , http_referer ) + 2 ) ) - 1 ) |
---|---|
http://www.phpschool.com/bbs2/inc_view.html?id=124... | www.phpschool.com |
http://blog.dreamwiz.com/media/folderListSlide.asp... | blog.dreamwiz.com |
http://www.google.com/search?hl=ko&newwindow=1&q=%... | www.google.com |
http://phpschool.com/bbs2/inc_view.html?id=12471&c... | phpschool.com |
http://www.phpschool.com/bbs2/inc_view.html?id=124... | www.phpschool.com |
http://www.parkoz.com/zboard/view.php?id=my_tips&p... | www.parkoz.com |