我在這段代碼中遇到了錯(cuò)誤，該錯(cuò)誤僅來自 'verification'< 25“小于”運(yùn)算符，當(dāng)我用它進(jìn)行更改時(shí)，=>它不會(huì)出現(xiàn)錯(cuò)誤。我如何重寫這個(gè)查詢？$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貢獻(xiàn)1834條經(jīng)驗(yàn) 獲得超8個(gè)贊
嘗試像下面這樣
$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 關(guān)注
- 126 瀏覽
添加回答
舉報(bào)
0/150
提交
取消