Full-Text Search in SQL

The Problem

`LIKE '%keyword%'` is slow and doesn't rank results by relevance.

PostgreSQL Full-Text Search

SELECT * FROM articles

WHERE to_tsvector('english', body) @@ to_tsquery('machine & learning');

Index for Speed

CREATE INDEX idx_fts ON articles USING GIN (to_tsvector('english', body));

*Day 92: Geospatial Queries with PostGIS.*