Build an easy search bar using only MySQL
In this video, we build a real search bar in MySQL (and it also works in MariaDB) using FULLTEXT indexes and MATCH() AGAINST().
You’ll learn:
How FULLTEXT indexing works at a high level (tokenizing words, handling stopwords, etc.)
How to query with MATCH() AGAINST()
The 3 search modes: Natural Language, Boolean Mode, and Query
Official documentation links
MySQL (Reference Manual)
Full-Text Search Functions (MATCH() AGAINST()):
https://dev.mysql.com/doc/en/fulltext...
Boolean Full-Text Searches (IN BOOLEAN MODE):
https://dev.mysql.com/doc/refman/8.4/...
Full-Text Searches with Query Expansion (WITH QUERY EXPANSION):
https://dev.mysql.com/doc/refman/9.5/...
Fine-Tuning Full-Text Search (min token size, word length, etc.):
https://dev.mysql.com/doc/refman/9.5/...
Full-Text Stopwords:
https://dev.mysql.com/doc/refman/9.1/...
MariaDB (Documentation)
MATCH ... AGAINST reference:
https://mariadb.com/docs/server/refer...
Full-Text Index Overview:
https://mariadb.com/docs/server/ha-an...
Full-Text Index Stopwords:
https://mariadb.com/docs/server/ha-an...
#mysql #mariadb #sql #fulltext #backend #webdev