Laravel whereRaw Query Example

by

Laravel whereRaw query example; Through this tutorial, i am going to show you what is whereRaw in laravel and how to use whereRaw query in laravel apps.

Example 1 – Laravel whereRaw Query

$orders = DB::table('orders')
                ->whereRaw('price > IF(state = "TX", ?, 100)', [200])
                ->get();

The whereRaw methods can be used to inject a raw “where” clause into your query.

Example 2 – Laravel whereRaw Query

    $users = User::whereRaw('YEAR(created_at) = ?', [date('Y')])->get();

Leave a Comment