search based on words priority

[Amit Kumar]

Hi Team,

I am working on a search query.
in this query , if I am searching for " word_1 word_2 word_3"
then I want the output in the below priority:

" word_1 word_2 word_3 "
" word_1 word_2 "
" word_1 word_3 "
" word_2 word_3 "
" word_1 "
" word_2 "
" word_3 "

I tried all the option available but not sure how to get this done in a query.



SELECT issue_id,
identifier,
summary,
SUBSTR(content_text,1,200) AS content ,
MATCH(CONTENT_text) against(REPLACE('word_1 word_2 word_3 word_4 ', ' ' , ' +') ) AS score
FROM HOOTSEARCH.HOOT_DATA
WHERE MATCH(CONTENT_text) against(REPLACE('word_1 word_2 word_3 word_4 ', ' ' , ' +') IN BOOLEAN MODE ) ;

here we are using score so we can order the result on the based of priority.


PLEASE HELP