조회 : 430
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 |
| 제목 |
|---|
| [기본형] HTML (with 부트스트랩5.3 , jquery 3.7, vue.js) |
| 유용한 리눅스(LINUX) 명령어 |
| [공지] 기술 게시판 |
일 |
월 |
화 |
수 |
목 |
금 |
토 |
|---|---|---|---|---|---|---|
|
4.26
|
4.27
|
4.28
|
4.29
|
4.30
|
5.1
|
5.2
|
|
5.3
|
5.4
|
5.5
|
5.6
|
5.7
|
5.8
|
5.9
|
|
5.10
|
5.13
|
5.14
|
5.15
|
5.16
|
||
|
5.17
|
5.18
|
5.19
|
5.20
|
5.21
|
5.22
|
5.23
|
|
5.24
|
5.25
|
5.26
|
5.27
|
5.28
|
5.29
|
5.30
|
|
5.31
|
6.1
|
6.2
|
6.3
|
6.4
|
6.5
|
6.6
|
