--- Michael Stassen <[EMAIL PROTECTED]> a
écrit :
> denys wrote:
>
> > SELECT country
> > FROM Rates
> > WHERE fieldvalue1 <> 0 AND fieldvalue2 <> 0 AND
> fieldvalue3 <> 0
> > ORDER BY country
> > is it what you want ?
> >
>
> Gleb Paharenko wrote:
>
> > Hello
> >
> > You may use query like this:
> > select country from rates where (fieldvalue1 !=0)
> and (fieldvalue2 !=0)
> > and (fieldvalue3 !=0) order by country;
> >
> > See:
> >
>
http://dev.mysql.com/doc/mysql/en/Comparison_Operators.html
>
> And since 0 is false and every other number is true,
> this could be
> simplified to
>
> SELECT country
> FROM Rates
> WHERE fieldvalue1 AND fieldvalue2 AND fieldvalue3
> ORDER BY country;
>
> Michael
>
>
I will go to bed less fool this evening... Is it just
a clearest way to write it, or is there some
performance issues too ?
Vous manquez d’espace pour stocker vos mails ?
Yahoo! Mail vous offre GRATUITEMENT 100 Mo !
Créez votre Yahoo! Mail sur http://fr.benefits.yahoo.com/
Le nouveau Yahoo! Messenger est arrivé ! Découvrez toutes les nouveautés pour
dialoguer instantanément avec vos amis. A télécharger gratuitement sur
http://fr.messenger.yahoo.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
