Raw select laravel

$results = DB::select('select * from users where id = :id', ['id' => 1]);

Source: laravel.com

Raw query in laravel with parameters

$someVariable = Input::get("some_variable");
$results = DB::select( DB::raw("SELECT * FROM some_table WHERE some_col = :somevariable"), array(
   'somevariable' => $someVariable,
 ));

DB::statement( 'ALTER TABLE HS_Request AUTO_INCREMENT=:incrementStart', array('incrementStart' => 9999) );

Raw queries in laravel

DB::statement('UPDATE users SET role_id = 1 WHERE role_id IS NULL AND YEAR(created_at) > 2020');

Source: quickadminpanel.com

Similar codes

2 votes235 views1 answer
Drop all database tables oracle sql developer
SQL
13 votes223 views4 answers
Mysql get last row
SQL
0 vote251 views2 answers
List all constraints in postgres
SQL
0 vote217 views1 answer
Mysql query single row
SQL
2 votes233 views1 answer
Add 2 hours to current time in MySQL
SQL
24 votes229 views6 answers
Replace mysql
SQL
0 vote241 views1 answer
Mariadb cast null to 0
SQL
8 votes253 views2 answers
Replace string value in sql
SQL
2 votes233 views2 answers
Postgres select duplicate columns
SQL
0 vote254 views1 answer
Sqlite woth cmake
SQL