Contractor UK Bulletin Board - View Single Post - Google Style Optimized Search of a Database

PerlOfWisdom · 22nd July 2008, 12:34

You need to set up an indexing table with values like:

John Smith
ohn Smith
hn Smith
n Smith
Smith
Smith
mith
ith
th

This allows indexed searches as there is no wildcard at the begining of the string.

22nd July 2008, 12:34	#3
PerlOfWisdom More time posting than coding Join Date: Jul 2005 Posts: 471	You need to set up an indexing table with values like: John Smith ohn Smith hn Smith n Smith Smith Smith mith ith th This allows indexed searches as there is no wildcard at the begining of the string.