Rails - how to find all rows where a certain column value is nil with where()

Question

I want to return an array with all rows in a table called bookings where the column returned_date is empty.

So far I've tried Booking.where("returned_date <> ''"), which chose all the records where returned_date is present, but I want an inverse selection of this.

Answer 1

If you mean to get with returned_date column be null:

Booking.where(returned_date: nil)