Chapter 7. Full-Text Searches
You are now able to build the next generation e-commerce platform but your search engine is not really efficient. You might like to search for multiple words in the name and description fields of your products, make complex queries, exclude words, or retrieve documents containing several specified words.
In order to achieve that, you will have to add the full-text search functionality to your database. Full-text searches give you the same power as any decent search engine. Moreover, a relevance score is given to each result so that you can sort the results that you show to your customers.
In this chapter, we will cover the following topics:
- Defining full-text search
- Full-text searches in MySQL and MariaDB
- Working with full-text indexes
- Full-text queries
- Mroonga
- Connecting MariaDB to Sphinx
