Rails raw SQL example

by

You can do this:

sql = "Select * from ... your sql query here"
records_array = ActiveRecord::Base.connection.execute(sql)

records_array would then be the result of your sql query in an array which you can iterate through.

More Related Contents:

  1. PostgreSQL GROUP BY different from MySQL?
  2. MySQL not using indexes with WHERE IN clause?
  3. Best way to count rows by arbitrary time intervals
  4. Disable Rails SQL logging in console
  5. ActiveRecord Arel OR condition
  6. LEFT OUTER JOIN in Rails 4
  7. Rails 3 execute custom sql query without a model
  8. Perform this hours of operation query in PostgreSQL
  9. Join multiple tables with active records
  10. PostgreSQL where all in array
  11. SQL where joined set must contain all values but may contain more
  12. Find records where join doesn’t exist
  13. Rails 4 LIKE query – ActiveRecord adds quotes
  14. Find all records which have a count of an association greater than zero
  15. Rails find record with zero has_many records associated [duplicate]
  16. Prepared Statement on Postgresql in Rails
  17. ActiveRecord find_each combined with limit and order
  18. Sort by column ASC, but NULL values first?
  19. Using an Alias column in the where clause in Postgresql
  20. How to get next/previous record in MySQL?
  21. MIN/MAX vs ORDER BY and LIMIT
  22. Reference alias (calculated in SELECT) in WHERE clause
  23. SQL – Select first 10 rows only?
  24. SQL – Inserting a row and returning primary key
  25. How do I start auto increment from a specific point?
  26. How to use a dynamic parameter in a IN clause of a JPA named query?
  27. Perform regex (replace) in an SQL query
  28. How to export data from Excel spreadsheet to Sql Server 2008 table
  29. Query a Table’s Foreign Key relationships
  30. How to get the next number in a sequence

Leave a Comment