My table name is pbook, in this i have lot fields ( 15 fields { name,
homeno, pnoheno, mobileno, buisnessno, address, city, state),


I have to implement the search facility,  if the i type a pattern it
should fetch the records from database, it should display the matched
records.

 but my requirement is if my pattern match with atleast one field in
pbook table it should display the records.


give me a query.  awaiting reply.

Thx in advance,
Manju.A.
-- 
Posted via http://www.ruby-forum.com/.