Show Columns where null <> 'Yes'

[paul13]

I only want to get the columns that are not null. I tried Show columns with combinations of 'like and where' along with "not null and null <> 'yes'"

nothing seems to work.

can anyone tell me where I can get good documentation on using show column?

thanks

paul13

[gio2k]

I think I didn't understand correctly.
You want to show only the columns that are not NULL, or do you want to show only the rows that don't have NULL values in a particular column.

SQL statements work on entire rows. If you want to leave out the rows where a particular column has NULL values, you use a SQL like this:

SELECT * FROM table WHERE column IS NOT NULL

On the other hand if you want to retrieve all rows but only show columns if they don't have NULL values, you'll have to do it by program.

-Gio-