Search Query

  • Thread starter Thread starter Kjuib
  • Start date Start date
K

Kjuib

I would like to make a query that will find matching
Strings in a field of a table. The problem comes in, that
I would like it to pull Records where the String is close
to the One I was looking for.

Example:
Search for String: Mutant Spider

Records Found:
Mutation
Spider
Mutant Spider
Mother Spider
Mutant
MutantSpider

Records Not Found:
Goat
Mouse House
BigTent
And other stuff that is not close to the Target String

Is there an easy way of doing this?
 
I would like to make a query that will find matching
Strings in a field of a table. The problem comes in, that
I would like it to pull Records where the String is close
to the One I was looking for.

Example:
Search for String: Mutant Spider

Records Found:
Mutation
Spider
Mutant Spider
Mother Spider
Mutant
MutantSpider

Records Not Found:
Goat
Mouse House
BigTent
And other stuff that is not close to the Target String

Is there an easy way of doing this?
Click to expand...

No.

"Similar" in this context is a concept that humans handle much better
than computers. Which of the following are similar? "Genetically
Engineered Arachnid"; "Spinoidal Decomposition"; "Muted Trumpets";
etc.

The closest you could do is have a query for FIELD LIKE "*" & [enter
search term] & "*" AND FIELD LIKE "*" & [Enter another search term:] &
"*"

and enter Mutant and Spider separately. This would NOT find the word
"Mutation" of course; that's a linguistic similarity, not a textual
one, and Access can't recognize that "Mutation" is any closer to
"Mutant" than "Transmutation" or "Immutable" are.
 
Back
Top