Its a PHP function my friend. I'm using 3,23...
--- DL Neil <[EMAIL PROTECTED]> &eacgr;&ggr;&rgr;&agr;&psgr;&egr;: >
Nick,
> Explode: which version of the MySQL manual are you
> using?
> =dn
>
> ----- Original Message -----
> From: "nick gatsis" <[EMAIL PROTECTED]>
> To: "Carlos Fernando Scheidecker Antunes"
> <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROTECTED]>
> Sent: Friday, August 09, 2002 2:33 PM
> Subject: Re: How to separate different domains on an
> e-mail database
>
>
> > You must create an extra field in your database to
> > store the domain.
> > Use the explode() to seperate the domain from ...@
> >
> > (array explode (string separator, string string [,
> int
> > limit])
> > Returns an array of strings, each of which is a
> > substring of string formed by splitting it on
> > boundaries
> > formed by the string separator. If limit is set,
> the
> > returned array will contain a maximum of
> > limit elements with the last element containing
> the
> > whole rest of string. If an empty string ("") is
> > used as the separator argument, then explode()
> will
> > return FALSE. If separator contains a value
> > that is not contained in the string argument,
> > thenexplode() will return the string argument.
> > Note: The limit parameter was added in PHP 4.0.1
> > Example 1. explode() example
> > $pizza = "piece1 piece2 piece3 piece4 piece5
> piece6";
> > $pieces = explode(" ", $pizza);
> > )Form PHP manual
> > Cheers
> >
> >
> > --- Carlos Fernando Scheidecker Antunes
> > <[EMAIL PROTECTED]> &eacgr;&ggr;&rgr;&agr;&psgr;&egr;: > Hello all,
> > >
> > > I've got an e-mail database of our subscribers
> and I
> > > would like to have a
> > > SQL statement do select DISTINCT domains.
> > >
> > > Meaning, I want to know all domains. I whish I
> could
> > > query it so that it
> > > would show me just once each domain, or
> everything
> > > that is after the @ sign.
> > >
> > > Does anyone knows how to query it?
> > >
> > > The e-mail field has 50 chars long. Each user
> > > (whatever is before the @) has
> > > a different lenght off course. So I need to list
> > > just once each domain.
> > >
> > > Any ideas or suggestions?
> > >
> > > Thank you in advance,
> > >
> > > C.F.
> >
> >
>
____________________________________________________________
> > Do You Yahoo!?
> > &Agr;&pgr;&ogr;&kgr;&tgr;&eeacgr;&sgr;&tgr;&egr; &tgr;&eegr; &dgr;&ohgr;&rgr;&egr;&aacgr;&ngr; @yahoo.gr &dgr;&igr;&egr;&uacgr;&thgr;&ugr;&ngr;&sgr;&eegr; &sgr;&agr;&sfgr; &sgr;&tgr;&ogr;
> http://www.otenet.gr
> >
> >
>
---------------------------------------------------------------------
> > Before posting, please check:
> > http://www.mysql.com/manual.php (the manual)
> > http://lists.mysql.com/ (the list
> archive)
> >
> > To request this thread, e-mail
> <[EMAIL PROTECTED]>
> > To unsubscribe, e-mail
>
<[EMAIL PROTECTED]>
> > Trouble unsubscribing? Try:
> http://lists.mysql.com/php/unsubscribe.php
> >
> >
>
____________________________________________________________
Do You Yahoo!?
&Agr;&pgr;&ogr;&kgr;&tgr;&eeacgr;&sgr;&tgr;&egr; &tgr;&eegr; &dgr;&ohgr;&rgr;&egr;&aacgr;&ngr; @yahoo.gr &dgr;&igr;&egr;&uacgr;&thgr;&ugr;&ngr;&sgr;&eegr; &sgr;&agr;&sfgr; &sgr;&tgr;&ogr; http://www.otenet.gr
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
