List:General Discussion« Previous MessageNext Message »
From:denys Date:November 19 2004 9:54am
Subject:Re: detect rows that has zero values
View as plain text  
Louie Miranda a écrit :

>Im trying not to list the rows that has zero values.
>
>this is my current select statement:
>
>select id,country_city from rates_ocean order by country_city
>
>The fields that i have to detect are:
>
>fieldvalue1
>fieldvalue2
>fieldvalue3
>
>how can i do this on mysql, ex:
>
>select country from rates (if fieldvalue1,fieldvalue2,fieldvalue3 = 0
>(do not display)) order by country;
>
>  
>
SELECT  country
FROM Rates
WHERE fieldvalue1 <> 0 AND fieldvalue2 <> 0 AND fieldvalue3 <> 0
ORDER BY country
is it what you want ?
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