I made an article search function. By default, the search results are sorted by the release time. I want to sort the results by the relevance of the search content. How can I do this?

I made an article search function. By default, the search results are sorted by the release time. I want to sort the results by the relevance of the search content. How can I do this? Mysql does not have this syntax, right? Is full-text indexing required for this function? Or Chinese Word Segmentation? I don't understand this... I made an article search function. By default, the search results are sorted by the release time. I want to sort the results by the relevance of the search content. How can I do this?

Mysql does not have this syntax, right?

Is full-text indexing required for this function?

Or Chinese Word Segmentation?

I don't understand this. Can I write SQL alone?

Another example is sorting some search results by sales volume, popularity, time, and combination. I want to know what this combination means and what sort will it?

Thank you!

Reply content:

I made an article search function. By default, the search results are sorted by the release time. I want to sort the results by the relevance of the search content. How can I do this?

Mysql does not have this syntax, right?

Is full-text indexing required for this function?

Or Chinese Word Segmentation?

I don't understand this. Can I write SQL alone?

Another example is sorting some search results by sales volume, popularity, time, and combination. I want to know what this combination means and what sort will it?

Thank you!

SQL alone is not possible unless you have a very sophisticated design.