Select queries in Laravel - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is the basic way to retrieve all records from a database table using Laravel's Eloquent?

Use the all() method on the Eloquent model, like User::all(). This returns all rows as a collection.

beginner

How do you select specific columns from a table using Laravel's query builder?

Use the select() method with column names, for example: DB::table('users')->select('name', 'email')->get().

beginner

What method do you use to add a condition to a select query in Laravel?

Use the where() method to filter results, like User::where('active', 1)->get() to get active users.

beginner

How can you get the first record matching a condition in Laravel?

Use the first() method after a query, for example: User::where('email', '[e-mail]')->first().

intermediate

What is the difference between get() and pluck() in Laravel select queries?

get() returns a collection of full records, while pluck() returns a collection of values from a single column, like User::pluck('email').

Which Laravel method retrieves all rows from a table as a collection?

A all()

B get()

C first()

D pluck()

The all() method returns all records from the model's table as a collection.

How do you select only the 'name' and 'email' columns using Laravel's query builder?

A pluck('name', 'email')

B where('name', 'email')

C select('name', 'email')

D get('name', 'email')

The select() method specifies which columns to retrieve.

Which method adds a filter condition to a Laravel query?

A limit()

B filter()

C select()

D where()

The where() method adds conditions to filter query results.

What does the first() method do in Laravel queries?

A Gets all records

B Gets the first record matching the query

C Gets the last record

D Gets a count of records

first() returns the first record that matches the query or null if none found.

Which method returns a collection of values from a single column in Laravel?

A pluck()

B get()

C all()

D first()

pluck() extracts values from one column into a collection.

Explain how to retrieve specific columns with conditions using Laravel's query builder.

Think about chaining methods to narrow down results and pick columns.

Describe the difference between get(), first(), and pluck() in Laravel select queries.

Focus on what each method returns and when to use them.