List:General Discussion« Previous MessageNext Message »
From:Bulant Denys Date:November 19 2004 3:33pm
Subject:Re: detect rows that has zero values
View as plain text  
 --- Michael Stassen <Michael.Stassen@stripped> 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
Thread
detect rows that has zero valuesLouie Miranda19 Nov
  • Re: detect rows that has zero valuesdenys19 Nov
  • Re: detect rows that has zero valuesGleb Paharenko19 Nov
    • Re: detect rows that has zero valuesMichael Stassen19 Nov
      • Re: detect rows that has zero valuesSGreen19 Nov
        • Re: detect rows that has zero valuesMichael Stassen19 Nov
      • Re: detect rows that has zero valuesBulant Denys19 Nov
        • Re: detect rows that has zero valuesMichael Stassen19 Nov
        • Re: detect rows that has zero valuesMartijn Tonies19 Nov