how to write this sql query in model of Ruby on rails

Question

SELECT *
FROM customers
WHERE customer_name NOT IN ( 'IBM', 'Hewlett Packard', 'Microsoft' );

I want to write a query in my task which is similar to the above query,and my task is in ruby on rails.

Have a look here guides.rubyonrails.org/active_record_querying.html It should solve your question and discribes how to do querys in Ruby. — MiBrock
– MiBrock, Commented Jun 30, 2015 at 9:44

Pavan · Accepted Answer · 2015-06-30 09:46:47Z

3

If you are using Rails 4, the following will do

Customer.where.not(customer_name: ['IBM', 'Hewlett Packard', 'Microsoft'])

For Rails versions lower than Rails 4, the below will work

Customer.where("customer_name NOT IN (?)", ['IBM', 'Hewlett Packard', 'Microsoft'])

answered Jun 30, 2015 at 9:46

Pavan

33.6k8 gold badges53 silver badges78 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1