我在使用LARAVEL VALIDATION时遇到一个问题。
我预计deleted_at
为null,但我得到的deleted_at
=null
'level_name' => 'unique:company_levels,level_name,' . $id . ',id,company_id,' . $company_id.',deleted_at,null',
它生成一个类似的查询
select count(*) as aggregate from `company_level` where `level_name` = 'Chennai' and `id` <> 1 and `company_id` = 3 and `deleted_at` = null
这不符合我的需要。
我需要生成如下的查询
select count(*) as aggregate from `company_level` where `level_name` = 'Chennai' and `id` <> 1 and `company_id` = 3 and `deleted_at` is null
提前感谢
通过将null替换为null来解决问题。
使用大写NULL替换NULL
退出查询
',deleted_at,null',
我用代替了它
',deleted_at,NULL',