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

10 votes133 views2 answers
Linux command line import mysql database
SQL
-1 vote128 views2 answers
How to select the lowest values from table per client sql
SQL
24 votes138 views4 answers
How to add column sql
SQL
1 vote134 views1 answer
Get count by weekly pivot table sql server
SQL
2 votes161 views1 answer
Removing view
SQL
0 vote154 views1 answer
Typical max-connect-errors mysql
SQL
0 vote141 views1 answer
What is the difference between the LIKE and REGEXP operators in mysql?
SQL
1 vote155 views1 answer
Add multiple row table pl sql
SQL
0 vote150 views1 answer
Postgresql if else endif
SQL
0 vote152 views1 answer
Porcentaje sql
SQL