# How to apply OR condition in model.find?

**URL:** <https://www.ruby-forum.com/t/how-to-apply-or-condition-in-model-find/194716>\
**Category:** Rails\
**Created:** [September 9, 2010, 1:33pm UTC](https://www.ruby-forum.com/t/how-to-apply-or-condition-in-model-find/194716 "2010-09-09T13:33:42Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![PalaniKannan\_K](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/p/eb8c5e/32.png) [@PalaniKannan\_K](https://www.ruby-forum.com/u/PalaniKannan_K)\
**Post date:** [September 9, 2010, 1:33pm UTC](https://www.ruby-forum.com/t/how-to-apply-or-condition-in-model-find/194716/1 "2010-09-09T13:33:42Z")

</div>

Hi,

@table\_names = TableName.find(:all, :conditions=\>{:column\_name =\>  
params[:gm], :column\_id =\> params[:id]})

Here, I used two conditions to find SQL. This two conditions applies  
with  
“AND”. I need to apply this two conditions with “OR” condition.

Applying “|” or "||"symbol fails… How I can apply OR condition, Kinldy  
help me.

–  
With Regards  
Palani Kannan. K  
Office: +49-531-2616-226  
Mobile: +4917647098166

---

<div class="post-metadata">

**Author:** ![PalaniKannan\_K](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/p/eb8c5e/32.png) [@PalaniKannan\_K](https://www.ruby-forum.com/u/PalaniKannan_K)\
**Post date:** [September 9, 2010, 2:48pm UTC](https://www.ruby-forum.com/t/how-to-apply-or-condition-in-model-find/194716/2 "2010-09-09T14:48:05Z")

</div>

On 9 September 2010 12:32, PalaniKannan K [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)  
wrote:

> Hi,
> 
> @table\_names = TableName.find(:all, :conditions=\>{:column\_name =\>  
> params[:gm], :column\_id =\> params[:id]})
> 
> Here, I used two conditions to find SQL. This two conditions applies with  
> “AND”. I need to apply this two conditions with “OR” condition.

Use the array form for conditions  
@table\_names = TableName.find(:all, :conditions=\>[ ‘column\_name = ? OR  
column\_id = ?’, params[:gm], params[:id] ])

Colin

---

<div class="post-metadata">

**Author:** ![PalaniKannan\_K](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/p/eb8c5e/32.png) [@PalaniKannan\_K](https://www.ruby-forum.com/u/PalaniKannan_K)\
**Post date:** [September 9, 2010, 3:31pm UTC](https://www.ruby-forum.com/t/how-to-apply-or-condition-in-model-find/194716/3 "2010-09-09T15:31:25Z")

</div>

Dear Collin…

Wooww… Excellent… Tanx @ extreme. I too tried with many examples  
obtained from online forums… This made me fun…

On 9 September 2010 14:43, Colin L. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote:

> @table\_names = TableName.find(:all, :conditions=\>[ 'column\_name = ? OR
> 
> > –  
> > removed\_email\_address@domain.invalid[removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)  
> > removed\_email\_address@domain.invalid[removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)  
> > .  
> > For more options, visit this group at  
> > [http://groups.google.com/group/rubyonrails-talk?hl=en](http://groups.google.com/group/rubyonrails-talk?hl=en).

–  
With Regards  
Palani Kannan. K  
Office: +49-531-2616-226  
Mobile: +4917647098166