How to implement a search on the site?

Question

PHP

It is necessary to implement a search on the site using the database tables, the classic option is, of course, LIKE. But with an increase in the number of records, I think it will work slowly.
And what are the more advanced methods for this task, especially for High load?

Answer 1

well, you have the sphinx and elasticsearch right in the tags

Answer 2

like this is slightly wrong, with a serious volume it's generally f*ck,
FTS is our answer to Chamberlain!

Answer 3

As usual, the answer in the
LIKE question is quite a normal option, first you need to live up to the Highload (hundreds of gigabytes of data, and preferably terabytes).
But it depends on the task: exact search, inexact search, maybe the user needs to be found in the admin panel, etc.