^
operator is used to boost the scores of individual fields by a constant. In the following query, description
is weighted twice as heavily as category
in the final BM25 score.
rating
. This means that items with
the same score but a higher rating
will score higher overall.
COALESCE
sets NULL
values of rating
to 1
.