Ruby rails - select only few columns from the data base

Kapish M picture Kapish M · Apr 21, 2012 · Viewed 69.8k times · Source

What is the way in rails to structure sql query to only select certain columns from the database, I have some large data fields which I want to avoid loading from continuous periodic ajax calls. Reading unnecessarily is resource consuming and slow.

@itemlist = Item.find(:all, :conditions => { .... } ) #this select all columns 

I am looking for SELECT name, address FROM users; instead of SELECT * FROM users;

Answer

nyaa picture nyaa · Apr 21, 2012

Rails 3:

Item.select("name, address").where( .... )