mysql 查询某个字段不为空（附thinkphp写法）

1.如果要写某个字段不为空，mysql的表达式应为：

假设字段为：door_open_api_key，

那么：door_open_api_key is  not null AND door_open_api_key != ""

 

2. thinkphp中应写为

        $Reserve_system = M('Reserve_system');
        $where = array();
        $where['door_open_api_key'] = array('exp',' is not null AND door_open_api_key != ""');
        $reserve_systems = $Reserve_system->where($where)->select();