直接上了
->where('name|title','like','thinkphp%')
结果
WHERE ( `name` LIKE 'thinkphp%' OR `title` LIKE 'thinkphp%' )
上面适合2个查一个的,但是如果是多个不相关的or 则可以
$where = [['nickname','=', 'a'], ['phone','=','135']]; $result = Db::name('user_card') ->where(['is_delete'=>1]) ->where(function($query) use ($where){$query->whereOr($where);}) ->select();
结果
ELECT * FROM `un2co_user_card` WHERE `is_delete` = 1 AND ( `nickname` = 'a' OR `phone` = '135' )