My users can currently type in simple keywords to find testimonials that are in the datbase. Here is my query:
SELECT tID, date, viewed, summary, MATCH (summary,testimony,keywords) AGAINST (‘$q’) AS score FROM testimonies WHERE MATCH (summary,testimony,keywords) AGAINST (‘$q’) and approved = ‘Yes’ limit 50
What is the best way to tweak my search page so that it supports using quotations, negative keywords, etc? I would like it to be similar to how Google works.
Thank you!