MySQL Regex or Split

[Eric Jensen]

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