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 ?
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
