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