DEV Community

Rohit Urane
Rohit Urane

Posted on

Mastering the Eloquent where Condition in Laravel

Image description

Laravel's Eloquent ORM (Object-Relational Mapping) is one of its standout features, offering a robust and expressive way to interact with your database. One essential functionality Eloquent provides is the method, that allows developers to filter queries efficiently and intuitively. In this article, we will delve deep into the where condition, exploring its various forms and practical use cases.

Basic Usage of where

The where method is used to add basic constraints to database queries. Here’s a simple example:

$users = User::where('status', 'active')->get();
Enter fullscreen mode Exit fullscreen mode

In this example, we are retrieving all users where the status column is active.

Syntax

The basic syntax of the where method is:

Model::where('column', 'operator', 'value');
Enter fullscreen mode Exit fullscreen mode

column: The name of the column.

operator: The comparison operator (e.g., =, >, <, >=, <=, !=). If omitted, = is assumed.

value: The value to compare the column against.

You can read more about an article on this post

Top comments (1)

Collapse
 
sloan profile image
Sloan the DEV Moderator

Hi there, we encourage authors to share their entire posts here on DEV, rather than mostly pointing to an external link.

Sharing your full posts helps ensure that readers don’t have to jump around to too many different pages, and it helps focus the conversation right here in the comments section on DEV.

To be clear, the DEV Terms state:

Posts must contain substantial content — they may not merely reference an external link that contains the full post.

Also, if you share your full post, you have the option to add a canonical URL directly to your post. This helps with SEO if you are reposting articles!