RE: Regexp / Sql-perl problem.

[Rich Buckley]

All,

> SELECT MID(email, LOCATE("@", email), 999) AS domain, COUNT(*) FROM 
> email_table GROUP BY domain;

Neat.

> I'm not sure about MID and LOCATE in other renditions of SQL though.

In Oracle MID would be SUBSTR but I cannot think of an alternative
to LOCATE.

Getting off track I s'pose, more of a SQL debate than Perl :(

--Rich