Gives way better search results. Results are assigned a score, based on their relevance relative to the course name (weight = 2) and the teacher's name (weight = 1).
Use of MySQL built-in fulltext search function, therefore fulltext indexes were added to courses.name, teachers.firstname and teachers.lastname.
Gives way better search results. Results are assigned a score, based on their relevance relative to the course name (weight = 2) and the teacher's name (weight = 1).
Use of MySQL built-in fulltext search function, therefore fulltext indexes were added to courses.name, teachers.firstname and teachers.lastname.