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 ...

Get MariaDB Essentials now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.