How to translate a MySQL-like query into Laravel Eloquent?

Question

Laravel

SELECT * FROM `books` WHERE books.type = 'rare' AND books.band - $value < $result

$books= DB::table('books')
                        ->where('type ','=', 'rare')
                        ->whereRaw('band - $value < $result')   // Syntax error

How it is possible to register dynamic variables in ->whereRaw? Or is it possible to translate the request in some other way?

Answer 1

Look what's there!