SELECt * from vocabulary WHERe translation like 'word' union allSELECt * from vocabulary WHERe translation LIKE '%word%' and translation not like 'word'
将首先列出完全匹配项

SELECt * from vocabulary WHERe translation like 'word' union allSELECt * from vocabulary WHERe translation LIKE '%word%' and translation not like 'word'
将首先列出完全匹配项