问在mySQL中匹配单词的一部分并按相关性排序

EN

SELECT 
    rcv_id,
    rcv_title,
    rcv_desc,
    (MATCH(rcv_title) AGAINST ('nur*')) AS title_relevance,
    (MATCH(rcv_desc) AGAINST ('nur*')) AS desc_relevance
FROM rc_vacancy
WHERE
    ( MATCH(rcv_title,rcv_desc) AGAINST ('nur*') )
    AND rcv_deleted = 'off'
    AND rcv_active = 'on'
    AND rcv_type = 'P'
ORDER BY title_relevance DESC, desc_relevance DESC, rcv_lastupdated

SELECT
    rcv_id,
    rcv_title,
    rcv_desc,
    (MATCH(rcv_title) AGAINST ('nurse')) AS title_relevance,
    (MATCH(rcv_desc) AGAINST ('nurse')) AS desc_relevance
FROM rc_vacancy
WHERE
    ( MATCH(rcv_title,rcv_desc) AGAINST ('nurse') )
    AND rcv_deleted = 'off'
    AND rcv_active = 'on'
    AND rcv_type = 'P'
ORDER BY title_relevance DESC, desc_relevance DESC, rcv_lastupdated

SELECT
    rcv_id,
    rcv_title,
    rcv_desc,
    (MATCH(rcv_title) AGAINST ('nur')) AS title_relevance,
    (MATCH(rcv_desc) AGAINST ('nur')) AS desc_relevance
FROM rc_vacancy
WHERE
    ( MATCH(rcv_title,rcv_desc) AGAINST ('nur') )
    AND rcv_deleted = 'off'
    AND rcv_active = 'on'
    AND rcv_type = 'P'
ORDER BY title_relevance DESC, desc_relevance DESC, rcv_lastupdated