How can I query raw via Eloquent?

by

You may try this:

// query can't be select * from table where
Model::select(DB::raw('query'))->get();

An Example:

Model::select(DB::raw('query'))
     ->whereNull('deleted_at')
     ->orderBy('id')
     ->get();

Also, you may use something like this (Using Query Builder):

$users = DB::table('users')
                 ->select(DB::raw('count(*) as user_count, status'))
                 ->where('status', '<>', 1)
                 ->groupBy('status')
                 ->get();

Also, you may try something like this (Using Query Builder):

$users = DB::select('select * from users where id = ?', array(1));
$users = DB::select( DB::raw("select * from users where username = :username"), array('username' => Input::get("username")));

Check more about Raw-Expressions on Laravel website.

More Related Contents:

  1. Laravel Check If Related Model Exists
  2. How to alias a table in Laravel Eloquent queries (or using Query Builder)?
  3. Laravel Eloquent: How to order results of related models?
  4. Laravel 4: how to “order by” using Eloquent ORM [duplicate]
  5. How to set a default attribute value for a Laravel / Eloquent model?
  6. Laravel Eloquent – Attach vs Sync
  7. How to create a subquery using Laravel Eloquent?
  8. Update without touching timestamps (Laravel)
  9. Eloquent model mass update
  10. Find or Create with Eloquent
  11. Laravel Many to many self referencing table only works one way
  12. How to Create Multiple Where Clause Query Using Laravel Eloquent?
  13. Get the Last Inserted Id Using Laravel Eloquent
  14. Laravel orderBy on a relationship
  15. Add a custom attribute to a Laravel / Eloquent model on load?
  16. MVC (Laravel) where to add logic
  17. How to exclude certains columns while using eloquent
  18. Laravel named route for resource controller
  19. How to alias the name of a column in Eloquent
  20. Laravel $q->where() between dates
  21. file_put_contents(meta/services.json): failed to open stream: Permission denied
  22. PHP Composer update “cannot allocate memory” error (using Laravel 4)
  23. laravel collection to array
  24. How can I install mcrypt under PHP7? Laravel needs it
  25. Eloquent Parent-Child relationship on same model
  26. How to send data using redirect with Laravel
  27. Laravel Auth:attempt() will not persist login
  28. Eloquent groupBy make “SQLSTATE[42000]” with valid SQL query in Laravel 5.3
  29. Avoid public folder of laravel and open directly the root in web server
  30. Laravel Eloquent update just if changes have been made

Leave a Comment