Select everything in the database that == something or something else

Question

I am trying to select everything in the table where the column == "something" OR "something".

Is there a way to do this without using raw SQL? Something like the following would be ideal.

Table.where(:col => "something" OR "somethingelse")

+3

Jon Jun 15 '11 at 20:32

3 answers

You can use:

MyModel.where("col1 = ? or col1 = ?", "something","somethingelse")

+2

Joe Jun 15 '11 at 20:35

You can use the operator as follows:

select * from table_name where column_name = value1 or column_name = value_2

You can also use:

select * from table_name where column_name in (value1,value2)

-1

Prateek Jun 15 '11 at 20:36

ryeguy · Accepted Answer · 2011-06-15T20:36:13+0000

Table.where(:col => ["something", "somethingelse"])

should generate

SELECT * FROM table WHERE col IN ('something', 'somethingelse')