使用LIKE时如何按大多数匹配对MySQL结果进行排序

I´m currently working on a query that must show a list of all articles from a specific table, but it must sort the list according to a search form, so that the articles that contain most/best matches are shown first and those that do not have any matches at all will be shown last sorted alphabetically.I´m currently working on a query that must show