Find with OR : Search « ActiveRecord « Ruby

1.	ActiveRecord
2.	Array
3.	CGI
4.	Class
5.	Collections
6.	Database
7.	Date
8.	Design Patterns
9.	Development
10.	File Directory
11.	GUI
12.	Hash
13.	Language Basics
14.	Method
15.	Network
16.	Number
17.	Rails
18.	Range
19.	Reflection
20.	Statement
21.	String
22.	Threads
23.	Time
24.	Tk
25.	Unit Test
26.	Windows Platform
27.	XML

Ruby » ActiveRecord » Search

Find with OR









Account.find :all, :conditions => [ "updated_on > ? OR id IN (?)",

                                    @last_update,

                                    [ 2, 3, 5, 7, 11 ] ]



It will result in the following SQL:



SELECT *

  FROM accounts

  WHERE

    updated_on > '20061214 15:29:12'

    OR id IN (2, 3, 5, 7, 11)

Related examples in the same category

1.	Find by column name
2.	Find by conditions
3.	id is default for find(1)
4.	A find_or_create_by_* dynamic finder
5.	Find many values
6.	Find first or find all
7.	Find with conditions
8.	Find with AND

java2s.com | Contact Us | Privacy Policy

All other trademarks are property of their respective owners.