where('field', null) is not working

does the $request->get('foobar') returns a value, dd it

In query builder you have method whereNull / whereNotNull

$users = DB::table('users')
                    ->whereNull('updated_at')
                    ->get();

https://laravel.com/docs/5.3/queries

http://stackoverflow.com/a/27982726

I tried this, and it works, maybe you should check $request->get('foobar') really return null?

$all = Permission::where('id', 10)->where('description', null)->get(); var_dump($all); exit;

or you can use whereNull, just add a judgement before use it.

Hey @rene !

You should check if the value of $request->get('foobar') is null or not when writing your query.

$query = Foobar::where('user_id', 1)

if (!is_null($request->get('foobar'))) {
  $query->where('second_id', $request->get('foobar'));
}

$query->first();

The reason for the where('second_id', null) doesn't work is that in SQL null = null is falsy (actually null). Most, if not all, SQL dialects have a null safe comparison method; In MySQL it's <=> and PostgreSQL has IS NOT DISTINCT FROM So adding the comparator parameter to the where method should do the trick: (For mysql)

Foobar::where('user_id', 1)->where('second_id', '<=>', $request->get('foobar'))->first();