我在這段代碼中遇到了錯誤，該錯誤僅來自 '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();
1 回答
MMMHUHU
TA貢獻1834條經驗 獲得超8個贊
嘗試像下面這樣
$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();
- 1 回答
- 0 關注
- 125 瀏覽
添加回答
舉報
0/150
提交
取消