Topic: Q: How can I select columns for my find results

I would like to refind the SQL statement that Rails creates when I do a find.  Right now my log shows the following:
SELECT * FROM users

I'd like to make it say:
SELECT id, name FROM users

In my controller I may have some code doing a find like the following, how would I modify it?

@user = User.find_all

Re: Q: How can I select columns for my find results

User.find(:all, :select => "id, name")

:-)

Re: Q: How can I select columns for my find results

Rock on!

Thx.