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

5 votes132 views3 answers
Bash: mysql: command not found
SQL
14 votes122 views3 answers
Sql trim from string
SQL
0 vote120 views1 answer
Postgresql on conflict pair
SQL
0 vote118 views1 answer
Mysql grant access to one database
SQL
1 vote114 views1 answer
Join first name and last name sql
SQL
1 vote108 views3 answers
How to truncate table with foreign key constraint
SQL
5 votes115 views2 answers
Oracle tables with column name
SQL
13 votes130 views3 answers
Insert mysql ifile nto database
SQL
2 votes122 views2 answers
How to add not null constraint in sql
SQL
2 votes116 views2 answers
Install sqlalchemy
SQL