Nov 21: Full-Text Search Queries
Learning Objectives
After today's class, you should be able to:
- Summarize how a full-text search query finds and ranks results.
- Write text search (
@@) and similarity search (%) queries in SQL.
Lesson Outline¶
Lecture [50 min]
- Full Text Search and Similarity Search
- Documentation:
- PostgreSQL Chapter 12. Full Text Search
- PostgreSQL Appendix F.35. pg_trgm
- MySQL 14.9 Full-Text Search Functions
Work Time [25 min]
- Add text search or similarity search to your project
- Brainstorm / coordinate design for HW6 documents