# Run sql query?

**URL:** <https://www.ruby-forum.com/t/run-sql-query/123056>\
**Category:** Rails\
**Created:** [December 13, 2007, 6:17pm UTC](https://www.ruby-forum.com/t/run-sql-query/123056 "2007-12-13T18:17:11Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![softf5ajivanet](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/9f8e36/32.png) [@softf5ajivanet](https://www.ruby-forum.com/u/softf5ajivanet)\
**Post date:** [December 13, 2007, 6:17pm UTC](https://www.ruby-forum.com/t/run-sql-query/123056/1 "2007-12-13T18:17:11Z")

</div>

hi i’ve got one action which i want it to perform a sql update query.

how can i just run a sql query within my rails app?

e.g.

def  
@sql = “update … from mytable”  
execute @sql  
redirect\_to :action =\> ‘list’  
end

any ideas?

---

<div class="post-metadata">

**Author:** ![softf5ajivanet](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/9f8e36/32.png) [@softf5ajivanet](https://www.ruby-forum.com/u/softf5ajivanet)\
**Post date:** [December 13, 2007, 6:25pm UTC](https://www.ruby-forum.com/t/run-sql-query/123056/2 "2007-12-13T18:25:49Z")

</div>

don’t worry, worked it out…

[http://softiesonrails.com/2007/7/23/performing-a-sql-update-in-rails](http://softiesonrails.com/2007/7/23/performing-a-sql-update-in-rails)

Image.update\_all ‘inform\_police = true’, ‘user = joker’

😉

John.

---

<div class="post-metadata">

**Author:** ![softf5ajivanet](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/9f8e36/32.png) [@softf5ajivanet](https://www.ruby-forum.com/u/softf5ajivanet)\
**Post date:** [December 13, 2007, 7:13pm UTC](https://www.ruby-forum.com/t/run-sql-query/123056/3 "2007-12-13T19:13:47Z")

</div>

On Dec 13, 2007, at 11:17 AM, John G. wrote:

> redirect\_to :action =\> ‘list’  
> end
> 
> any ideas?

I’ve done it two ways:

1. Model.connection.execute(sql)

and

1. ActiveRecord::Base.connection.execute(sql)

Not sure which way is considered more proper, though.

Peace,  
Phillip

---

<div class="post-metadata">

**Author:** ![softf5ajivanet](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/9f8e36/32.png) [@softf5ajivanet](https://www.ruby-forum.com/u/softf5ajivanet)\
**Post date:** [December 13, 2007, 8:57pm UTC](https://www.ruby-forum.com/t/run-sql-query/123056/4 "2007-12-13T20:57:12Z")

</div>

nice, i’ll have a look at that, thanks.

John.