如何查询数据库中为空的值

Created 8 years ago by yxalls, Updated 8 years ago Revision #1 4887 views 0 likes 0 collects

我需要查询数据库某字段值为空的数据，下面的laravel会把所有记录都给查询出来。
$name = '';
$users = user::where('ro_role_id','=',$name)->first();

求大神指点指点

Vote Vote Cancel

Collect Collect Cancel

@yxalls#33 你这个字段默认是空字符串还是NULL

$user= User::where('ro_role_id',null)->first();