search

pudo / dataset

Easy-to-use data handling for SQL data stores with support for implicit table creation, bulk loading, and transactions.
https://dataset.readthedocs.org/
MIT License
4.76k stars 297 forks source link

find columns whose value is/is not NULL #401

Closed xoich closed 2 years ago

xoich commented 2 years ago

Hi, it seems that is not possible to do such a query with the method find. Since it's a simple query I i think there should be a way to do it without resorting to the more complex query methods.

xoich commented 2 years ago

it cane be done with find(col=None)

JasonCrowe commented 1 year ago

You can also use:

find(col={'!=': None})

for is not null.