Database: Raw SQL Select Query

 
<?php

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

$users = DB::select('select * from users where id = 1');

$users = DB::select('select * from users where name like ?', ['%john%']);

$users = DB::select('select * from users where name like "%john%"');

?>

 

Related Snippets

•  Query Builder: Get value of an aggregated field
•  Database: Insert, Update, Delete
•  Query Builder: Insert, Update, Delete
•  Query Builder: Get single value of a field from one record
•  Database: Using PDO
•  Query Builder: Get max value of a field