其实可以在代码中进行排序,但是能用sql语句 为什么不用呢
@Query("select * from weather_city_table where city_name LIKE '%' || :message || '%' order by case when city_name = :message then 1 when city_name LIKE :message || '%' then 2 when city_name LIKE '%' || :message || '%' then 3 when city_name LIKE '%' || :message then 4 else 0 END")
fun getCityName(message: String): MutableList<CityTable>
自行替换相应的名称就ok了。