List:General Discussion« Previous MessageNext Message »
From:Louie Miranda Date:November 19 2004 7:37am
Subject:detect rows that has zero values
View as plain text  
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;

-- 
Louie Miranda
http://www.axishift.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