MySQL Regex or Split

Eric Jensen eric at emstraffic.com
Wed Apr 27 11:02:58 MDT 2005


Trying to make some queries a little more efficient.  I want to group
HTTP referers together but not with the full URL.  For example, just
"www.google.com" instead of the full search string.  I can't find a way
to do this in MySQL.  Is there a way to turn
"http://search.msn.com/results.aspx?q=things+stuff&FORM=SSRE" into
"search.msn.com" in a SELECT statement?  Otherwise I have to loop
through them all and parse them myself and run more queries then necessary.

Eric Jensen



More information about the PLUG mailing list