조회 : 109
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 |
| 제목 | 작성자 | 날짜 |
|---|---|---|
| 공대여자 | ||
| 공대여자 | ||
| mins01 | ||
| 공대여자 | ||
| 공대여자 | ||
| 공대여자 | ||
| 공대여자 | ||
| 공대여자 | ||
| 공대여자 | ||
| 공대여자 | ||
| 공대여자 | ||
| 공대여자 | ||
| 공대여자 | ||
| mins | ||
| mins | ||
| mins | ||
| mins | ||
| mins |
