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?

score 1 · Accepted Answer · edited May 23 '17 at 10:34

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 '17 at 10:34

Community

1
1

answered Feb 28 '12 at 14:09

Janci

3,198
1
21
22

Thanks. This is useful. I can't vote your answer, but I will as soon as I can. – Taz Feb 28 '12 at 14:42

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

1 Answers1