Use number in where condition in Laravel Query

Question

The below query works well in mysql but how to represent the same thing using Laravel.

select * from user_subscription where vendor_id = 'user_100' 
and 0 = (select count(*) from user_restricted_dates where vendor_id = 'user_100')

I tried with code but gives error as unknown column '0' in where clause

$list = UserSubscription::where('vendor_id', '=', $vendor_obj->vendor_id)
    ->where(0, '=', "(select count(*) from user_restricted_dates where vendor_id = 'user_100'")
    ->get();

Well the error indicates what it is but how to represent it

user6705732 · Accepted Answer · 2017-03-25 19:24:47Z

2

The where method of the Query Builder maps the first value you pass to a field in the model. You'd have to use the whereRaw method instead.

$list = UserSubscription::where('vendor_id', '=', $vendor_obj->vendor_id)
    ->whereRaw("0 = (select count(*) from user_restricted_dates where vendor_id = 'user_100')")
    ->get();

answered Mar 25, 2017 at 19:24

user6705732

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Use number in where condition in Laravel Query

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related