I'm having trouble to write query in laravel eloquent ORM
.
我的问题是
SELECT book_name,dt_of_pub,pub_lang,no_page,book_price
FROM book_mast
WHERE book_price NOT IN (100,200);
现在我想把这个问题转化为laravel eloquent.
I'm having trouble to write query in laravel eloquent ORM
.
我的问题是
SELECT book_name,dt_of_pub,pub_lang,no_page,book_price
FROM book_mast
WHERE book_price NOT IN (100,200);
现在我想把这个问题转化为laravel eloquent.
Query Builder:
DB::table(..)->select(..)->whereNotIn('book_price', [100,200])->get();
Eloquent:
SomeModel::select(..)->whereNotIn('book_price', [100,200])->get();