Purpose
This function is mainly used for string matching or full-text retrieval in database fields.
Syntax
SCORE(score_label)
Parameters
score_label: Optional. The matching number of the returned result, inNUMBERtype.
Examples
Run the following command to implement a full-text retrieval and sorting query using CONTAINS and SCORE.
obclient> SELECT column1, column2, ...
FROM table_name
WHERE CONTAINS(indexed_column, 'search_query'[, score_label]) > 0
ORDER BY SCORE(score_label) DESC;