- @Query("SELECT DISTINCT description, CASE WHEN description_uc LIKE :term||'%%' THEN 1 " +
- " WHEN description_uc LIKE '%%:'||:term||'%%' THEN 2 " +
- " WHEN description_uc LIKE '%% '||:term||'%%' THEN 3 " +
+ @Query("SELECT DISTINCT description, CASE WHEN description_uc LIKE :term||'%' THEN 1 " +
+ " WHEN description_uc LIKE '%:'||:term||'%' THEN 2 " +
+ " WHEN description_uc LIKE '% '||:term||'%' THEN 3 " +