关系 SQL 查询数组 DB::table()-> select() ->where()->get()

Question

我收到此代码的错误，错误仅来自'verification'< 25当我用=>更改它时，"小于"运算符是问题所在，它不会出现错误。如何重写此查询？

$allRecords = DB::table('users')->select(DB::raw('CONCAT(name, " ", last_name) AS name'),'email as email_address')->where(array('verification'< 25,'is_admin'=>0,'is_approved'=>1))->orderby('id', 'DESC')->get();

Answer 1

尝试如下

$allRecords = DB::table('users')
->select(DB::raw('CONCAT(name, " ", last_name) AS name'),'email as email_address')
->where('verification', '<', 25)
->where(array('is_admin'=>0,'is_approved'=>1))
->orderby('id', 'DESC')
->get();