Level 41
No, you can just preface any where method with 'or', these are built in methods.
For situations like this I prefer using whereRaw.
Dec 26, 2014
7
Level 2
Eloquent for orWhere isNull
Can I use eloquent like this:
$query->where($field, $value)->orWhereIsNull($field)->orWhereNotIn($field, $array)->get();
?
Basically can I preface any advance where function with 'or' and will it still work?
Level 2
By any where method does that include the advance where methods too?
Level 41
I didn't get what you meant, can you clarify please ?
anyway, here's an example from Laravel documentation :
$users = User::whereRaw('age > ? and votes = 100', array(25))->get();
And this is more advanced where methods you can use
DB::table('name')->whereBetween('column', array(1, 100))->get();
DB::table('name')->whereIn('column', array(1, 2, 3))->get();
DB::table('name')->whereNotIn('column', array(1, 2, 3))->get();
DB::table('name')->whereNull('column')->get();
DB::table('name')->whereNotNull('column')->get();
Source : http://cheats.jesse-obrien.ca/
2 likes
Level 2
I'm basically asking if these methods exist in Eloquent:
DB::table('name')->orWhereBetween('column', array(1, 100))->get();
DB::table('name')->orWhereIn('column', array(1, 2, 3))->get();
DB::table('name')->orWhereNotIn('column', array(1, 2, 3))->get();
DB::table('name')->orWhereNull('column')->get();
DB::table('name')->orWhereNotNull('column')->get();
Level 41
Yes, they do exists and you can use them with Eloquent too.
4 likes
Level 2
Thanks!! :)
Level 41
You are welcome :)
Please or to participate in this conversation.