Laravel where Not Between clause Example

We are going to fetch data with whereNotBetween clause in laravel from the table emp.

DB::table('emp')->whereNotBetween('salary',[10000,20000])->get();

Will Generate the following query.

//Select * from emp where salary NOT BETWEEN 10000 AND 20000 ;

Laravel where Between clause Example

We are going to fetch data with whereBetween clause in laravel from the table emp.

DB::table('emp')->whereBetween('salary',[10000,20000])->get();

Will Generate the following query.

//Select * from emp where salary BETWEEN 10000 AND 20000 ;

Laravel where clause Example 1

We are going to fetch data with where clause in laravel from the table emp.

DB::table('emp')->where('salary', '=',10000)->get();

Will Generate the following query.

//Select * from emp where salary = ‘10000’;

Laravel where clause Example 2

DB::table('emp')->where('salary', '<',10000)->get();

Will Generate the following query.

//Select * from emp where salary < '10000';

Laravel truncate table example

Below is the simple example for Laravel truncate table

DB::table('users')->tuncate();

Will truncate the users table.

Syntax : Laravel delete all records from table example

Below is the simple example for Laravel delete all records from table

DB::table('users')->delete();

Will delete all records from table.

Laravel delete query example with Syntax

Below is the simple Laravel Delete query Example

DB::table('users')->where('id', '=', 66)->delete();

Will delete the record where id is 66.

Laravel join query example

DB::table('users')
          ->join('city','city.user_id','=','users.id')
          ->select('users.name','city.city_name')
         ->get();