C
C
Cathari2021-03-08 20:38:20
Laravel
Cathari, 2021-03-08 20:38:20

How to translate Mysql query to Laravel?

SELECT * FROM `books` WHERE books.author = 'kipling' AND books.popularity > 150 AND books.popularity - 150 < 100


$books= DB::table('books')
                        ->where('author ','=', 'kipling')
                        ->where('popularity ','>', 150)...

and something like I don’t twist I don’t understand how to write "AND books.popularity - 150 < 100"

Answer the question

In order to leave comments, you need to log in

1 answer(s)
I
Ilya, 2021-03-08
@Cathari

Here's an easier option than raw:
books.popularity - 150 < 100
books.popularity < 100 + 150
books.popularity < 250
These three entries are equivalent. School course of mathematics)

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question