title: How to run simple MYSQL query using rails
body: <p>I want run a simple MYSQL query using rails</p>
  
  
  
  <pre><code>Select movie-title, movie-director from moving order by rating desc limit 5;
  </code></pre>
  
  <p>I don't want all the overhead creating models. I just want to run the query.</p>
  
  <p>What is the best way to do this?<br>
  I cannot even connect</p>
  
  <p>Here is my the code from my controller</p>
  
  <pre><code>ActiveRecord::Base.establish_connection ({
  :adapter =&gt; "mysql2",
  :host =&gt; "some-rds.amazon.com",
  :username =&gt; "root",
  :password =&gt; "root",
  :database =&gt; "blah"})
  </code></pre>
  
  <p>This will generate this error
  ActiveRecord::ConnectionNotEstablished</p>
  
  <p>thanks</p>