method

select_rows

v4.2.7 - Show latest stable - 1 note - Class: ActiveRecord::ConnectionAdapters::DatabaseStatements

1.0.0
1.1.6
1.2.6
2.0.3 (0)
2.1.0 (8)
2.2.1 (0)
2.3.8 (0)
3.0.0 (0)
3.0.9 (-38)
3.1.0 (0)
3.2.1 (0)
3.2.8 (0)
3.2.13 (0)
4.0.2 (0)
4.1.8 (0)
4.2.1 (0)
4.2.7 (0)
4.2.9 (0)
5.0.0.1 (0)
5.1.7 (0)
5.2.3 (0)
6.0.0 (0)
6.1.3.1 (0)
6.1.7.7 (0)
7.0.0 (0)
7.1.3.2 (0)
7.1.3.4 (0)
What's this?

select_rows(sql, name = nil, binds = []) public

Returns an array of arrays containing the field values. Order is the same as that returned by columns.

# File activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb, line 57
      def select_rows(sql, name = nil, binds = [])
      end

April 9, 2009

1 thank

Like select_values for multiple values

The names are somewhat confused:

Model.connection.select_values("SELECT id,name FROM users") => ["1","2","3"]
Model.connection.select_rows("SELECT id,name FROM users") => [["1","amy"],["2","bob"],["3","cam"]]

select_rows

Related methods

Like select_values for multiple values