How to initialize custom mysql variable in Laravel 4?

Question

MySQL

I want to execute a query with the @total variable:

SET @total = 0;
SELECT ...
    @total := @total + x AS total_x,
    ...
WHERE
    @total < 1000

Through phpMyAdmin the request works. Problems in Laravel. Tried both in one call: DB::select( DB::raw( $query)), and in two consecutive ones:

DB::statement( DB::raw( 'SET @total := 0'));
$results = DB::select( $query); // тут только "select.."

How to be and what to do?

Answer 1

DB::unprepared() will save you.