ThinkPHP查询多字段为空或者为NULL的where语句

一、where写法

1. 写法一：

   $where = [
               'is_delete' => 0,
               'mobile_number_a' => [['=',''], ['null',''], 'or'],
               'mobile_number_b' => [['=',''], ['null',''], 'or'],
               'wechat_number' => [['=',''], ['null',''], 'or'],
               'landline_number_a' => [['=',''], ['null',''], 'or'],
               'landline_number_b' => [['=',''], ['null',''], 'or'],
               'email' => [['=',''], ['null',''], 'or'],
           ];

2. 写法二：

   $where = [
               'is_delete' => 0,
               'mobile_number_a&mobile_number_b&wechat_number&landline_number_a&landline_number_b&email' => [['=',''],['null',''],'or'],
           ];

二、生成SQL语句

SELECT * 
FROM `doc_new_project` 
WHERE  `is_delete` = 0  
    AND ( `mobile_number_a` = '' or `mobile_number_a` IS NULL )  
    AND ( `mobile_number_b` = '' or `mobile_number_b` IS NULL )  
    AND ( `wechat_number` = '' or `wechat_number` IS NULL )  
    AND ( `landline_number_a` = '' or `landline_number_a` IS NULL )  
    AND ( `landline_number_b` = '' or `landline_number_b` IS NULL )  
    AND ( `email` = '' or `email` IS NULL );