query for null values in web2py DAL

Question

Using the web2py DAL, how do a create a query to select for records will NULL values in a particular field?

Answer 1

Use this pattern: db(db.table.field==None).select()