PHP

laravel whereRaw

$Query = DB::table('some_table')->where('YEAR(date)', 'YEAR(CURRENT_DATE)');
SELECT * FROM `some_table` WHERE `YEAR(date)` = `YEAR(CURRENT_DATE)`
  
$Query = DB::table('some_table')->whereRaw('YEAR(date) = YEAR(CURRENT_DATE)');
SELECT * FROM `some_table` WHERE YEAR(date) = YEAR(CURRENT_DATE)

laravel whereRaw

use IlluminateSupportFacadesDB;

$first = DB::table('users')
            ->whereNull('first_name');

$users = DB::table('users')
            ->whereNull('last_name')
            ->union($first)
            ->get();