MySQL getting not empty rows

[AN-net]

how should i go about getting not empty rows for a particular field/column? should i use foobar!='' or something else?

[Marco van Herwaarden]

Dependinng on the contents of the 'empty' columns (i guess you want to retrieve the content of the rows that have a value for a certain column), it would be either:
- column <> ''
- column <> 0
- column IS NOT NULL

[AN-net]

ok thanks
edit:
the type of column is varchar, it seems to be yielding no results...but i know that some of them are empty.

the sql query i am running is:
[sql]
"SELECT journal_id, whocanview FROM " . TABLE_PREFIX . "journals WHERE whocanview IS NOT NULL"
[/sql]

[Marco van Herwaarden]

does the column allow NULL values, if no, what is the default value.

[AN-net]

Originally Posted by MarcoH64

does the column allow NULL values, if no, what is the default value.

how do i know if it does?

[Marco van Herwaarden]

Describe the table, look in phpMyAdmin, look in the scripts that created it.

[AN-net]

under the column labeled "null" it says no for that field so i guess using IS NOT NULL will not work?

[Marco van Herwaarden]

Correct, the column will then contain the default value.

try with: column <> ''

[AN-net]

Originally Posted by MarcoH64

Correct, the column will then contain the default value.

try with: column <> ''

that worked ty, your da best

[Marco van Herwaarden]

I know.