How to do the best search among the products on the site?

Question

SQL

How to do a search on the site, for example, as on Avito, not only the name of the ad is searched there ... but there is also a search for the content of the main text, or to make like tags for the product, well, again, the product is added by users and tags will be done for the search it right? How is this done on sites like Avito and so on?

Answer 1

What is the best way to do a site search?
on Avito including the Sphinx - see Sphinx Faceted Search

Answer 2

Google "full text search".