In this article, we will see laravel where and orWhere condition example. we will give you a very simple example of the laravel where() and orWhere() condition and also we will give you an example of where() and orWhere in a single query in laravel 6/7/8. You can use the where and orwhere method in laravel 6, laravel 7, and laravel 8.
For the where() and orWhere() methods the first argument is the name of the column. The second argument is an operator, which can be any of the database's supported operators. The third argument is the value to compare against the column's value.
So, let's see laravel 7/8 where query and laravel 7/8 orwhere query.
$users = DB::table('users')
->where('id', '=', 10)
->where('department', '=', 'web development')
->where('age', '>', 35)
->get();
Now I will show you an example of orWhere() query in laravel 6/7/8 and how to write orWhere() condition in laravel. So first we will see SQL query for better understanding.
SELECT * FROM users WHERE id='10' OR salary='20000';
Example of orWhere() condition in laravel 6/7/8
$users = DB::table('users')
->where('salary', '>', 20000)
->orWhere('name', 'Maria')
->get();
In this tutorial, I will guide you through the process of changing the start date of a datepicker component in Angular 1...
Jul-03-2023
As an Angular 15 developer, I understand the importance of incorporating image upload functionality with a progress bar...
Jun-21-2023
Hello Guys, In this tutorial we will see how to add datatable custom export button example. datatable provide inbuilt...
Apr-26-2021
In this article we will see jquery appendTo() and prependTo example. The appendTo() method inserts HTML elements at...
Dec-13-2021