Find by column name : Search « ActiveRecord « Ruby






Find by column name



=begin

create database Contact;

use Contact;

CREATE TABLE Employee (
   Name VARCHAR(50),
   Phone VARCHAR(15)
);

=end

require "rubygems"
require "activerecord"

ActiveRecord::Base.establish_connection(
  :adapter => "mysql",
  :host => "localhost",
  :username => "root",
  :database => "Contact")

class Employee < ActiveRecord::Base
   set_table_name "employee"
   set_primary_key "Name"
end

account = Employee.find_by_Name("AAA")
puts account.Name

 








Related examples in the same category

1.Find by conditions
2.id is default for find(1)
3.A find_or_create_by_* dynamic finder
4.Find many values
5.Find first or find all
6.Find with conditions
7.Find with AND
8.Find with OR