# Running raw SQL in rails console

**URL:** https://meta.discourse.org/t/running-raw-sql-in-rails-console/112015
**Category:** Development
**Created:** [March 19, 2019, 7:59am UTC](https://meta.discourse.org/t/running-raw-sql-in-rails-console/112015 "2019-03-19T07:59:59Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![csmu](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/csmu/32/124581_2.png) [@csmu](https://meta.discourse.org/u/csmu)
#### Post date: [March 19, 2019, 7:59am UTC](https://meta.discourse.org/t/running-raw-sql-in-rails-console/112015/1 "2019-03-19T07:59:59Z")

</div>

How do you run raw SQL in the rails console?

---

<div class="post-metadata">

### Author: ![csmu](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/csmu/32/124581_2.png) [@csmu](https://meta.discourse.org/u/csmu)
#### Post date: [March 19, 2019, 7:42pm UTC](https://meta.discourse.org/t/running-raw-sql-in-rails-console/112015/2 "2019-03-19T19:42:48Z")

</div>

> <https://stackoverflow.com/questions/4483049/how-to-execute-a-raw-update-sql-with-dynamic-binding-in-rails/4484549#4484549>

---

<div class="post-metadata">

### Author: ![sam](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/sam/32/102149_2.png) [@sam](https://meta.discourse.org/u/sam)
#### Post date: [March 19, 2019, 10:31pm UTC](https://meta.discourse.org/t/running-raw-sql-in-rails-console/112015/3 "2019-03-19T22:31:57Z")

</div>

See: [GitHub - discourse/mini\_sql: a minimal, fast, safe sql executor · GitHub](https://github.com/discourse/mini_sql)

EG:

```plaintext
DB.query('select * from users limit 1').first.username

```