In addition to the Metamorph searches listed above there is another type
of search based on Metamorph. This will return rows in order of
relevance, with the most relevant record first.
LIKER calculates a
relevance based solely on the presence or absence of the terms in the
LIKEP uses this same information, but also uses the proximity
of the terms to calculate relevance.
There are several restrictions and points to note about
The conditions that must be met to obtain a relevancy search are that a
Metamorph index exists on the field in question.
only work with an index. The other condition is that the query must
consist of word terms only. None of the other pattern matchers are
The query is a list of terms to be searched for. The words are weighted by their uniqueness in the document set being searched. This means that infrequent words are weighted more than common words.
The weight that was calculated for the record is available by selecting
the generated field $rank, which will contain the rank value. The
rank value for
LIKER is unscaled. With
LIKEP the number will range between
0 and 1000.
For fuller details on using the logic operators in