[Resolved] Querying on non empty fields

php_2004

Hi,

I was wondering, is it possible to create a "query" that would only return records where a field had been set??

for example

field 1 | field 2 | field3 |

cat | hello | goat |

| | goat |

cat | hello | goat |

As you see record 1 and 3 have been set on field 1, so is it possible that i could return just these. (record 2 has been set but i don't wish to return this because, not all of the fields have been completed)

Thanks for any advice or help in advance.

bastien

WHERE COLUMN_NAME is NOT NULL

php_2004

hi again, thanks for the reply

its still returning all of the records, even though some are blank?

i used:

SELECT * from table WHERE name is NOT NULL;

mrhappiness

are they NULL meaning no content at all or do they have content, an empty string for example?

try

SELECT * from table WHERE name != '';

note that '' is two ' and not one " 🙂

php_2004

thanks,

that works great !!!