usage of find_by_sql to delete record

Question

I'm trying to delete few records from table 'abc' where id is fetched from 'xyz' table

SQL:

delete from abc where id in (select ids from xyz where i= 10)

this query i want to execute using find_by_sql to avoid multiple hits to database.

It's giving error. Please help me in getting this delete action done in a single hit to DB.

Answer 1

I don't think find_by_sql is the method you want.

If you have

class Abc < ActiveRecord::Base
end

(so abc.rb is your model) then I think you should be able to do something like this:

Abc.connection.execute('delete from abc where id in (select ids from xyz where i= 10)')