Levelup

🕵️‍♀️ Task

Select all records from the movies table that have been directer by Christopher Nolan.

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

where 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 find in that column. The value could be any type of object, but the Class should usually match the type of column you’re searching in.

You can use an Array of as a value and include a list of values that you’d like to find in the column you’re searching in.

Data

id	title	year	duration	description	image	director_id

Data

id	name	dob	bio	image

Data

id	name	dob	bio	image
261	Bruce Hopkins	1955-11-25		http://ia.media-imdb.com/im...
262	Paris Howe Strewe
263	Alexandre Rodrigues	1983-05-21		http://ia.media-imdb.com/im...
264	Leandro Firmino	1978-06-23
265	Phellipe Haagensen
266	Douglas Silva
267	Jonathan Haagensen	1983-02-23
268	Matheus Nachtergaele	1969-01-03	Matheus Nachtergaele was bo...

Data

id	actor_id	movie_id	name
289	120	20	Peregrin 'Pippin' Took
290	257	20	Sharku / Snaga
291	258	20	Éothain
292	259	20	Grima Wormtongue
293	260	20	Haleth
294	126	20	Theoden
295	261	20	Gamling
296	262	20	Théodred - Prince of Rohan

Examples

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

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

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

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

Select the records from the cities table that have the values: 13, 25, and 63 in the id column.

City.all.where({ :id => [13, 25, 63]})
=> #<City::ActiveRecord_Relation:0x00007fa4341e1ee8>