--- 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]