Full-Text Search – ITFROMZERO – Share tobe shared!

Mastering Vietnamese Search in MySQL: From Sluggish LIKE to Optimized Full-Text Search

By admin August 8, 2026

Don't let search features slow down your system. Discover how to combine Shadow Columns and MySQL Full-Text Search for seamless accented and unaccented Vietnamese queries.

Database

PostgreSQL Full-Text Search: High-Performance Vietnamese Search Without Elasticsearch

By admin May 19, 2026

Don't rush to install Elasticsearch! A detailed guide on building high-speed, accurate Vietnamese search directly in PostgreSQL using only tsvector and GIN Index.

MySQL

MySQL Full-Text Search: The Secret to Super-Fast and Accurate Search for Your Applications

By admin March 11, 2026

Search functionality is vital for many applications, but `LIKE` often leads to poor performance. This article guides you on using MySQL Full-Text Search to build super-fast, effective search with relevance ranking directly within your database.