Using MySQL, filter $_GET variables from HTTP['QUERY_STRING']

Question

A MySQL (5.5.8) table (named usage_log) stores thousands of PHP $_SERVER['REQUEST_URI'] variables:

 id     | request_uri
--------|---------------------------------------------------------
 ...    | ...
 123456 | page_one.php?foo=123&bar=smtgh1&more=no&even_more=yes
 123457 | page_two.php
 123458 | page_twelve.php?get=123&a=letter
 ...    | ...

Using MySQL query, I want to filter names of $_GET variables from request_uri strings, to receive something like this:

 get_vars
--------------------------------
 ...
 foo, bar, more, even_more
 get, a
 ...

This definitely looks like a job for regexp but MySQL regexp function returns 0 or 1, so there's not much use of it, I guess. Is what I want even feasible in My SQL?

Community · Accepted Answer · 2017-05-23 10:34:50Z

1

You can't do this directly in MySQL but you could use MySQL User-defined functions. Hovever, I'd advise to do this transformation in PHP if possible.

Related/duplicate SO questions:

edited May 23, 2017 at 10:34

CommunityBot

11 silver badge

answered Feb 28, 2012 at 14:09

Janci

3,2741 gold badge25 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

TazGPL Over a year ago

Thanks. This is useful. I can't vote your answer, but I will as soon as I can.

Collectives™ on Stack Overflow

Using MySQL, filter $_GET variables from HTTP['QUERY_STRING']

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related