How use use multi compare with one where() in laravel eloquent query?

Question

In laravel elequent query how to make these two where select in one.

I also feels if there too many conditions, I've too use too many where clause.

->where('trade_status', '<>', 'TRADE_FINISHED')
->where('trade_status', '<>', 'TRADE_SUCCESS')

Possible duplicate of [How to create multiple where clause query using Laravel Eloquent?](http://stackoverflow.com/questions/19325312/how-to-create-multiple-where-clause-query-using-laravel-eloquent) — KhorneHoly, Jan 11 '17 at 08:41

score 2 · Accepted Answer · answered Jan 11 '17 at 08:47

2

Use whereNotIn():

->whereNotIn('trade_status', ['TRADE_FINISHED', 'TRADE_SUCCESS']);

answered Jan 11 '17 at 08:47

Alexey Mezenin

Prafulla Kumar Sahu · Answer 2 · 2017-01-11T08:46:56.747

1

Here in documentation you can notice

You can pass array of condition like

$users = DB::table('users')->where([
    ['status', '=', '1'],
    ['subscribed', '<>', '1'],
])->get();

for your condition it should be like

 DB::table('your_table')->where([
    ['trade_status', '<>', 'TRADE_FINISHED'],
    ['trade_status', '<>', 'TRADE_SUCCESS'],
])->get();

edited Jan 11 '17 at 08:46

answered Jan 11 '17 at 08:43

here if i can omit the = character? – LF00 Jan 11 '17 at 08:46
1

yes, use a simple where, the = can be omitted like this where( 'status', '1'), I will checked is it ok in the complex where. – LF00 Jan 11 '17 at 08:49
yes, there are a few ways you can do it as documentation shows . – Prafulla Kumar Sahu Jan 11 '17 at 08:51

2 Answers2