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