MySQL FULLTEXT Search

Episode #386 by Teacher's Avatar David Kimura

Summary

In this episode, we look at implementing full-text search in MySQL. Using some of the built in functions of MySQL, we are able query tables and add weighted results.
rails database mysql search 18:59

Chapters

  • Introduction (0:00)
  • Setting up Docker Compose (1:16)
  • Setting up scaffold (5:00)
  • Create simple search form (5:13)
  • Highlight results (6:57)
  • Simple search filtering (8:22)
  • Simple search demo (9:24)
  • Full-text search (10:29)
  • Create full-text migration (13:19)
  • Full-text demo (17:13)
  • Final thoughts (18:07)
Student & Teacher
$ 9 /mo

Valid School Email Required

Same Access as Pro

Subscribe Now
Pro Monthly
$ 19 /mo

Access to Pro Episodes

Invite to Slack Channel

Priority Suggestions

Ad Free

Subscribe Now
Pro Annual
$ 190 /yr

Access to Pro Episodes

Invite to Slack Channel

Priority Suggestions

Ad Free

Subscribe Now
Teams
$ 57 /mo

3 Users Minimum

$19.00 / user / month

Same Access as Pro

Subscribe to Teams