Count by substr ?

[ned911]

Here's what I want to do:

Table contains search engine domain names (www.google.com, www.google.fi, www.yahoo.com, etc).

I would like to count each search string but only by the middle value. Basically perform a split but in MySQL.

Output would be:

google 15
yahoo 10
jeeves 5

My SQL is pretty weak, any help would be appreciated.

Ned

Here is what I did in the select statement:

substring_index(engine,'.',2) as domain

Not perfect but it works pretty good.