how to use sql select statements in ruby?

Answer 1

require 'rubygems'
require_gem 'mysql'

my=Mysql::new("localhost","root","pass","mydb")

results=my.query("Select * from table")

row=results.fetch_row

(row will contain an array of the values in each column. You can repeat the fetch_row to get the rest of the rows and process each one.)