As far as the exact expression you want... well, rather than show off my ignorance, I'll just sit here silently and let you think that I'm smarter than I really am.
Eric Jensen wrote:
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 .===================================. | This has been a P.L.U.G. mailing. | | Don't Fear the Penguin. | | IRC: #utah at irc.freenode.net | `==================================='
.===================================. | This has been a P.L.U.G. mailing. | | Don't Fear the Penguin. | | IRC: #utah at irc.freenode.net | `==================================='
