Articles with Tags: sql

Using Is NOT NULL in query builder

When building where clauses it's not that well documented how to use NOT and NULL . Starting with a simple query: [snippet id=214] If we wanted to select all posts where the content had something in it [snippet id=215] Note the doubles set of square brackets, first before the 'not' and then around the parameters

[more...]