What is full text search in MYSQL How is it implemented ?

Full-text search is a feature of some database management systems that allows users to search for specific words or phrases within a set of text columns in a database.

It is an advanced search feature that goes beyond simple keyword matching, and can support features such as Boolean operators, wildcards, and stemming (finding words with the same root).

In MySQL, full-text search is implemented using full-text indexes and the MATCH() function.

A full-text index is a special index that is created on one or more text columns in a table, and is used to speed up full-text searches on those columns.

The MATCH() function is used to perform a full-text search on the indexed columns, and returns a relevance score for each row based on the relevance of the search term to the row.

To implement full-text search in MySQL, you will need to do the following:

Determine which columns in your table you want to be searchable. These columns should contain text data, and should be indexed using a full-text index.

Create a full-text index on the chosen columns. This can be done using the CREATE INDEX or ALTER TABLE statement.

Use the MATCH() function in a SELECT statement to perform a full-text search on the indexed columns. The MATCH() function takes a list of columns as its arguments,

and a search string as its value.

It returns a relevance score for each row based on the relevance of the search term to the row