ALTER TABLE articles ADD FULLTEXT INDEX ft_title_content (title, content);

SELECT id, title
FROM articles
WHERE MATCH(title, content) AGAINST('+mysql -oracle' IN BOOLEAN MODE);

ALTER TABLE articles ADD COLUMN tsv tsvector
  GENERATED ALWAYS AS (to_tsvector('simple', title || ' ' || content)) STORED;
CREATE INDEX idx_articles_tsv ON articles USING GIN (tsv);

SELECT id, title FROM articles
WHERE tsv @@ plainto_tsquery('simple', 'mysql');