# Custom sql query

**URL:** <https://www.ruby-forum.com/t/custom-sql-query/134079>\
**Category:** Rails\
**Created:** [April 7, 2008, 5:19pm UTC](https://www.ruby-forum.com/t/custom-sql-query/134079 "2008-04-07T17:19:10Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![fero](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/f/b2d939/32.png) [@fero](https://www.ruby-forum.com/u/fero)\
**Post date:** [April 7, 2008, 5:19pm UTC](https://www.ruby-forum.com/t/custom-sql-query/134079/1 "2008-04-07T17:19:10Z")

</div>

Hello.

How can I run custom slq query? I want to delete all rows from table,  
which is not mapped to activerecord model. Thanks.

Fero.

---

<div class="post-metadata">

**Author:** ![fero](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/f/b2d939/32.png) [@fero](https://www.ruby-forum.com/u/fero)\
**Post date:** [April 7, 2008, 5:31pm UTC](https://www.ruby-forum.com/t/custom-sql-query/134079/2 "2008-04-07T17:31:14Z")

</div>

On 7 Apr 2008, at 16:19, Frantisek P. wrote:

> Hello.
> 
> How can I run custom slq query? I want to delete all rows from table,  
> which is not mapped to activerecord model. Thanks.

ActiveRecord::Base.connection.execute ‘…’

(there’s also ActiveRecord::Base.connection.delete,  
ActiveRecord::Base.connection.insert,  
ActiveRecord::Base.connection.update etc… which you should use if  
possible as these will invalidate the query cache)

Fred