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

1 vote293 views1 answer
Psql view enum values
SQL
1 vote241 views1 answer
Sql myisam vs innodb
SQL
0 vote291 views1 answer
Python mysql show databases
SQL
0 vote318 views1 answer
Mssql find deadlocks
SQL
3 votes280 views1 answer
Oracle list privileges
SQL
1 vote286 views2 answers
Mysql limit offset
SQL
0 vote286 views1 answer
Mysql remove bad character from all fields
SQL
0 vote311 views2 answers
Mysql cast to varchar
SQL
0 vote252 views4 answers
How to drop all tables in sql
SQL
0 vote299 views1 answer
Yesql
SQL