20210827 正規表達式

, regexp_substr(request, '(^[^ ]+ )') AS method
    , regexp_extract(request, '^[^ ]+ .* ([^ ]+$)') AS url1
    , regexp_extract(request, '^[^ ]+ (.*) [^ ]+$') AS url
    , regexp_substr(request, '([^ ]+$)') AS protocol 
    , regexp_extract(referer, '^[^/]+://([^/]+){1}') AS referer --通過正則清晰refer，得到更精準的URL。
           

GET /wp-admin/admin-ajax.php?postviews_id=8638&action=postviews&=1392143929233 HTTP/1.1

200

15

上海市 GET

HTTP/1.1 /wp-admin/admin-ajax.php?postviews_id=8638&action=postviews&=1392143929233

HTTP/1.1