In this Laravel db raw query example tutorial, I’ll show you how to use db raw query in laravel. In this tutorial you will also learn how to use DB::raw() with join() method in laravel eloquent model. In laravel DB::raw() eloquent method you can also add subquery in laravel queries. In laravel you can use db raw queries to insert, retrieve, update, and delete data into database table. In this article we will demonstrate you the different use case of the db raw queries.

Laravel retrieve all records using DB raw query

In laravel to retrieve all records you can use db raw query as following:

Example:-

Delete using DB raw query

To delete data from the database table you can use DB raw query as following:

Example:-

DB raw With Select Clause Query in laravel

Sometimes in laravel you come to situations where you would need raw queries in your controller or model. In various cases in laravel you may need to use a raw expression in a query. In laravel you can write raw queries using DB as following:

Example:-

Laravel DB Raw Query With Join

You can implement raw join queries using DB raw as following:

Using DB Raw Get Max Value in Laravel Query

In laravel you can get max values using db raw as following: