Level 1
Try this by your model name:
BookMast::whereNotIn('book_price', [100, 200])->get(['book_name', 'dt_of_pub', 'pub_lang', 'no_page', 'book_price'])
1 like
Jun 2, 2022
3
Level 1
Laravel Eloquent "WHERE NOT IN"
I'm having trouble to write query in laravel eloquent ORM.
my query is
SELECT book_name,dt_of_pub,pub_lang,no_page,book_price FROM book_mast WHERE book_price NOT IN (100,200); Now I want to convert this https://e-chats.com/omegle query into laravel eloquent.
Level 55
@juna222 you asked it somee days ago and I give you the answer, no?
BookMast::select('book_name', 'dt_of_pub', 'pub_lang', 'no_page', 'book_price')
->wheereNoIn('book_price', [100, 200])
->get();
possiblee you neeed whereNotBetween instead of whereNotIn
BookMast::select('book_name', 'dt_of_pub', 'pub_lang', 'no_page', 'book_price')
->wheereNoBetween('book_price', [100, 200])
->get();
1 like
Level 75
Somebody asked it 7 years ago...
https://stackoverflow.com/questions/25849015/laravel-eloquent-where-not-in
1 like
Please or to participate in this conversation.