I need to create an "Advanced Search"

Databases
1

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!

2

embedded quotes, if needed, would have to be encoded in your search string

negatives would be implemented with the minus sign

see http://dev.mysql.com/doc/refman/5.1/en/fulltext-boolean.html

3

My new advanced search is working wonderful. Thanks!