Eloquent ignore zero, but don't ignore NULL

I want ignore ZERO category. But it is also ignoring NULL.

Product::where('category', '<>', 0)->first();
Product::where('category', '!=', 0)->first();
Product::where('category', '!==', 0)->first();
Product::whereNotIn('category', [0])->first();

jlrdw

4 years ago

Best Answer

Level 75

See this https://stackoverflow.com/questions/35922093/why-does-a-sql-query-with-0-not-include-null-values

andyandy

4 years ago

Level 4

@jlrdw Thanks, I didn't know that, so I did something like this.

Product::where(function($query){
	$query->where('category', '!=', 0)->orWhereNull('category');
})->first();

Please or to participate in this conversation.