Levelup

🕵️‍♀️ Task

Select records from the movies table that don't have the value 2009 in the year column.

movies

id (integer)
title (string)
year (integer)
duration (integer)
description (text)
image (string)
director_id (integer)

directors

id (integer)
name (string)
dob (date)
bio (text)
image (string)

actors

id (integer)
name (string)
dob (date)
bio (text)
image (string)

characters

id (integer)
actor_id (integer)
movie_id (integer)
name (string)

📖Method

You can negate criteria with where.not. Like where, where.not is used for filtering a collection of records down using various criteria. Most commonly, we pass a Hash argument. The key is the column you’re searching in and the value is what you’re trying to exclude from the results.

Data

id	title	year	duration	description	image	director_id

Data

id	name	dob	bio	image

Data

id	name	dob	bio	image
620	Jessica Kate Meyer			http://ia.media-imdb.com/im...
621	Julia Rayner			http://ia.media-imdb.com/im...
627	Roddy Skeaping
628	Ben Harlan
629	Mark Wahlberg	1971-06-05	American actor Mark Wahlber...	http://ia.media-imdb.com/im...
630	Ray Winstone	1957-02-19	Ray Winstone was born on Fe...	http://ia.media-imdb.com/im...
631	Vera Farmiga	1973-08-06	Vera Farmiga is a Ukrainian...	http://ia.media-imdb.com/im...
632	Anthony Anderson	1970-08-15		http://ia.media-imdb.com/im...

Data

id	actor_id	movie_id	name
625	562	44	Linda McFly
626	563	44	Sam Baines
627	564	44	Stella Baines
628	565	44	Mr. Strickland
629	566	44	Skinhead (as Jeffrey Jay Co...
630	567	44	3-D
631	568	44	Match
632	569	44	Marvin Berry

Examples

Select all records from the users table that _don't_ have "joe" in the first_name column.

User.all.where.not({ :first_name => "joe" })
=> #<User::ActiveRecord_Relation:0x00007fa4341e1ee8>

Select all records from the dishes table that _don't_ have 20 in the price column.

Dish.all.where.not({ :price => 20 })
=> #<Dish::ActiveRecord_Relation:0x00007fa4341e1ee8>