Word search in a database
From: <mmem_at_usa.net>
Date: 1999/01/28
Message-ID: <78ptnb$98q$1_at_nnrp1.dejanews.com>#1/1
Date: 1999/01/28
Message-ID: <78ptnb$98q$1_at_nnrp1.dejanews.com>#1/1
Hi,
We wish to search for names inside a db. There is a single field in the database, which constains strings like "Dr. Davis, Bill and Irene". We want to match either "Dr. Davis", "Irese Weiss", "Weiss Irene", etc.
The problem is that it is a hugh database (ten million records); Searching without some indexes is inpractical.
Any suggestions ?
-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Jan 28 1999 - 00:00:00 CET