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.
embedded quotes, if needed, would have to be encoded in your search string
negatives would be implemented with the minus sign
My new advanced search is working wonderful. Thanks!