# Custom query

**URL:** <https://www.ruby-forum.com/t/custom-query/182666>\
**Category:** Rails\
**Created:** [February 1, 2010, 9:53am UTC](https://www.ruby-forum.com/t/custom-query/182666 "2010-02-01T09:53:53Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![M\_I\_R](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/839c29/32.png) [@M\_I\_R](https://www.ruby-forum.com/u/M_I_R)\
**Post date:** [February 1, 2010, 9:53am UTC](https://www.ruby-forum.com/t/custom-query/182666/1 "2010-02-01T09:53:53Z")

</div>

Hi,  
i want to select only product id and product name from a table how  
will i manage please help

---

<div class="post-metadata">

**Author:** ![M\_I\_R](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/839c29/32.png) [@M\_I\_R](https://www.ruby-forum.com/u/M_I_R)\
**Post date:** [February 1, 2010, 10:10am UTC](https://www.ruby-forum.com/t/custom-query/182666/2 "2010-02-01T10:10:06Z")

</div>

M I R wrote:

> Hi,  
> i want to select only product id and product name from a table how  
> will i manage please help

Use

find\_by\_sql(SQL statement)

or use

find\_by\_product\_id\_and\_product\_name…

---

<div class="post-metadata">

**Author:** ![M\_I\_R](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/839c29/32.png) [@M\_I\_R](https://www.ruby-forum.com/u/M_I_R)\
**Post date:** [February 1, 2010, 10:37am UTC](https://www.ruby-forum.com/t/custom-query/182666/3 "2010-02-01T10:37:48Z")

</div>

> Use
> 
> find\_by\_sql(SQL statement)

You can also pass :select option to your find e.g.:

Product.find :all, :select=\>“id, name”

## Regards, Rimantas

[http://rimantas.com/](http://rimantas.com/)