Laravel 4: how to run a raw SQL?

by

In the Laravel 4 manual – it talks about doing raw commands like this:

DB::select(DB::raw('RENAME TABLE photos TO images'));

edit: I just found this in the Laravel 4 documentation which is probably better:

DB::statement('drop table users');

Update: In Laravel 4.1 (maybe 4.0 – I’m not sure) – you can also do this for a raw Where query:

$users = User::whereRaw('age > ? and votes = 100', array(25))->get();

Further Update If you are specifically looking to do a table rename – there is a schema command for that – see Mike’s answer below for that.

More Related Contents:

  1. Laravel redirect back to original destination after login
  2. Migration: Cannot add foreign key constraint
  3. Laravel Eloquent groupBy() AND also return count of each group
  4. Eloquent Collection: Counting and Detect Empty
  5. Laravel – Route::resource vs Route::controller
  6. How to install Laravel 4 to a web host subfolder without publicly exposing /app/ folder?
  7. How can I resolve “Your requirements could not be resolved to an installable set of packages” error?
  8. Laravel Redirect Back with() Message
  9. global variable for all controller and views
  10. Eloquent eager load Order by
  11. How can I remove a package from Laravel using PHP Composer?
  12. Laravel Fluent Query Builder Join with subquery
  13. How to Get the Current URL Inside @if Statement (Blade) in Laravel 4?
  14. laravel with() method versus load() method
  15. Rollback one specific migration in Laravel
  16. Laravel Controller Subfolder routing
  17. How to use paginate() with a having() clause when column does not exist in table
  18. Where can I set headers in laravel
  19. What is the difference between queue:work –daemon and queue:listen
  20. Validation of array form fields in laravel 4 error
  21. Best Practices for Laravel 4 Helpers and Basic Functions?
  22. How to access model hasMany Relation with where condition?
  23. Laravel 4: Failed to open stream: Permission denied
  24. Laravel save / update many to many relationship
  25. First Or Create
  26. Laravel: Returning the namespaced owner of a polymorphic relation
  27. Laravel: Change base URL?
  28. Polymorphic Eloquent relationships with namespaces
  29. Laravel 4 : Route to localhost/controller/action
  30. Clone an Eloquent object including all relationships?

Leave a Comment