Breaking News: Grepper is joining You.com. Read the official announcement!

eloquent where raw

Add Answer

Tiago F2 answered on August 20, 2021 Popularity 10/10 Helpfulness 4/10

answer eloquent where raw

related laravel select raw where

related eloquent where raw

eloquent where raw

Comment

/*
whereRaw / orWhereRaw
The whereRaw and orWhereRaw methods can 
be used to inject a raw "where" clause into your query. 
These methods accept an optional array of bindings as their second argument:
*/
$orders = DB::table('orders')
                ->whereRaw('price > IF(state = "TX", ?, 100)', [200])
                ->get();

Popularity 10/10 Helpfulness 4/10 Language php

Source: laravel.com

Tags: eloquent php raw where

Link to this answer
Share Copy Link

Contributed on Aug 20 2021

Tiago F2

0 Answers Avg Quality 2/10

Closely Related Answers

laravel select raw where

Comment

 User::query()
                ->where('users.ban', '!=', 1)
                ->where('users.rights', '=', 1)
                ->leftJoin('users as referal', 'users.id', '=', 'referal.ref_id')
                ->whereNotNull('referal.id')
                ->select([
                    'users.id',
                    'users.name',
                    'users.telegram_id',
                    DB::raw('count(referal.id) as total_referal'),
                    DB::raw("(SELECT COUNT(ac_r.id) FROM users as ac_r WHERE ac_r.ref_id=users.id AND ac_r.ref_bonus = 1) as active_referal"),
                    DB::raw("(SELECT COUNT(ac_r.id) FROM users as ac_r WHERE ac_r.ref_id=users.id AND ac_r.ref_bonus != 1) as no_active_referal"),
                    DB::raw("((SELECT COUNT(ac_r.id) FROM users as ac_r WHERE ac_r.ref_id=users.id AND ac_r.ref_bonus = 1) * ".User::REFERAL_BONUS.") as total_money_referal"),
                ])
                ->groupBy('users.id')
   ->orderByDesc('total_referal')->paginate(100);

Popularity 10/10 Helpfulness 4/10 Language php

Source: Grepper

Tags: laravel

Link to this answer
Share Copy Link

Contributed on Oct 09 2022

Shadow

0 Answers Avg Quality 2/10

eloquent where raw

Comment

$query->whereRaw("(
        LOWER(name)             like '%". strtolower($search) ."%' OR
        LOWER(sku)              like '%". strtolower($search) ."%' OR
        LOWER(codigo)           like '%". strtolower($search) ."%' OR
        LOWER(descricao_curta)  like '%". strtolower($search) ."%'
    )");

Popularity 10/10 Helpfulness 4/10 Language php

Source: Grepper

Tags: eloquent eloquen

Link to this answer
Share Copy Link

Contributed on Aug 20 2021

Tiago F2

0 Answers Avg Quality 2/10

eloquent where raw

Contents

More Related Answers

eloquent where raw

Closely Related Answers

laravel select raw where

eloquent where raw

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.