Re: Extracting hostname from URI column

> And what I'd like is something that would give me the counts for the
> number of occurrences of each unique hostname.  Something much like
> `uniq -c'.  Can anyone tell me how that's done or where I should look
> for info? (I'm not sure what to look for, that's the problem).
> 

select substring( ... ), count(1) from your_table group by 1;


      
____________________________________________________________________________________
Be a better Globetrotter. Get better travel answers from someone who knows. Yahoo! Answers - Check it out.
http://answers.yahoo.com/dir/?link=list&sid=396545469