Quote:
Originally Posted by PerlOfWisdom
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.
|
Wow, that's a great idea! I wonder how big the database will be if you do that for every word in every column across 55,000,000 rows?
__________________
By the time you finish reading this sentence, the national debt will have risen by another £1,500 - which you or your children will have to repay.
Just so you know.
|