Rails: Find Column Null, not Null or Empty

rails_find_empty_or_null_column.org

Rails: Find Column Null, not Null or Empty

Let’s find records where column is null or empty using Active Record

Article.where(topic: [nil, ""])

Let’s now find records where column is NOT null or empty using Active Record

Article.where.not(topic: [nil, ""])

This Active Record expression will be converted to the following SQL query.

SELECT "articles.*" 
FROM "articles"
WHERE 
NOT (("articles"."topic" = '' OR "articles"."topic" IS NULL))