select only values 0

Dear All, from a single row of a table, I have to select only the column, which have a value larger '0' into an outfile. How can I manage it with 'select'? Thanks, Jan Virus checked by G DATA AntiVirusKit Version: AVK 15.0.2975 from 09.02.2005 -- MySQL General Mailing List For

Re: select only values 0

You can't conditionally select columns with a mere select statement.. In whatever langauge you are using to process (perl, Java, whatever) you are going to have to select the entire row and use locig to pick out the columns that you want - michael dykman On Thu, 2005-02-17 at 11:44, Jan

Re: select only values 0

Dear All, from a single row of a table, I have to select only the column, which have a value larger '0' into an outfile. How can I manage it with 'select'? Thanks, Jan SELECT CASE can do that sort of thing for you. Here's a simplistic example: CREATE TABLE `test` ( `i1` int,