part 2 laravel all type of where conditions queries | where(), orWhere(), WhereBetween()

In this post we will discuss all type of where conditions in laravel query builder.some of them where, orWhere, whereBetween, whereNotBetween, whereIn

different type of where conditions

1. where()
2. orWhere()
3. whereBetween()
4. whereNotBetween()
5. whereIn()
6. multiple where conditions

where()

$insert = DB::table('student')->where('id','3')->get();

orWhere()

$insert = DB::table('student')->where('id','3')->orWhere('name','anmol')->get();

whereBetween()

where between method calculate all rows between given range in second parameter.

$insert = DB::table('student')->whereBetween('id', [2,6])->get();

whereIn()

whereIn query builder method take all rows that ids given in array.

$insert = DB::table('student')->whereIn('id', [2,3,6,8])->get();

multiple where conditions

in this example add multiple where conditions by function

$insert = DB::table('student')->whereIn('name', 'anmol')
		->orWhere(function($query){
			$query->where('name','webtut');
			$query->where('id', '<' ,'webtut');
		})->get();

watch all query builder playlist click on sidebar playlist link

Related tutorial links

• laravel query builder introduction tutorial
• part 1 laravel query insert data
• part 2 laravel all type of where conditions in query builder
• part 3 laravel whereDate, whereYear and whereTime qyery method
• part 4 compare two db columns in laravel query builder
• part 6 laravel pluck method get single column value
• part 7 laravel select and addselect query in query builder
• part 5 laravel first and find queries
• part 8 laravel edit and update method query explaination
• Part 9 laravel query for update or insert data by one method
• part 10 laravel delete vs truncate vs drop method
• part 11 gropupby and orderby query tutorial
• Part 12 laravel union of two queries
• part 13 laravel all aggregate functions with example
• part 14 laravel query builder chunk method
• part 15 laravel exists() and doesntExist() method
• part 16 laravel paginate vs simplePaginate method
• part 17 laravel all join methods