How to strip off email domain for sorting by domain?

2002-05-02 Thread Andrew Kuebler
I use Perl/DBI with MySQL and I'm trying to find a way to sort email addresses by domain. I would assume there is probably an option in MySQL to strip off the text after the '@' sign that will allow me to sort on. In Perl: @fields = split(/@/, $email); My domain would be displayed as:

Re: How to strip off email domain for sorting by domain?

2002-05-02 Thread Arjen Lentz
Hi, On Fri, 2002-05-03 at 02:43, Andrew Kuebler wrote: I use Perl/DBI with MySQL and I'm trying to find a way to sort email addresses by domain. I would assume there is probably an option in MySQL to strip off the text after the '@' sign that will allow me to sort on. In Perl: @fields =