PHP how to search database?

Question

Laravel

Greetings! The task is this: you need to make a good search in the database so that words and combinations are entered in the field on the site and he can find from the column in the database even if these words are not next to each other. There will also be other fields on the site that set parameters. It is necessary that they are also taken into account if selected. What is worth google to organize it, preferably with a good dock so that you can figure it out and integrate with Laravel.

Answer 1

Laravel Scout

Answer 2

Maybe a search engine like Sphinx is right for you

Answer 3

If you have Postgre as a database, then it has full-text search out of the box, which is great friends with Scout .
If there is another database, then look towards Elastic or Sphinx , which are also very easy to make friends with Laravel.
If you have any questions I'm ready to answer.