Improve accuracy of the results when searching for extensions from the Extension Manager UI

The current search results are of a very low accuracy:

• "syntax" -> "Syntax Highlighting Application" on the 11th spot
• "home page" -> "Home Page Application" on the 14th spot
• etc...

The top results usually have nothing to do with the searched term because, from what I can see from the code, the query used for the search does not do any "ORDER BY".

Basically we would need to start ordering the results, preferably prioritising titles over descriptions and so on.

Here are 2 options:

1. Use ORDER BY CASE in the existing HQL queries.
   • HQL example
   • SQL example
   • Quickest to implement, but DB "LIKE" queries are not the fastest.
2. Use Solr if available in the running environment and maybe fallback on 1.
   • A bit longer to implement, but better query performance.