Execute direct SQL in rails

[xmitchx]

Hello,

How may I execute direct SQL in code?

Thanks

[vgarcia]

You need to use find_by_sql

def self.find_by_url (url_title_variable = "index")
  find_by_sql ["select * from pages where url_title = ?", url_title_variable]
end

[samsm]

There is also MyModel.connection.select("Whatever SQL query you want right here")

as shown to me here: http://www.sitepoint.com/forums/show...06#post2232921

[xmitchx]

Thanks sam and vinnie. Both helped