The Query:
SELECT * FROM sendto WHERE description LIKE '%%%s%%'
To run it as a fulltext query, you need to replace that SELECT statement with this one:
SELECT *, MATCH(description) AGAINST ('SEARCHVARIABLE') AS score FROM sendto where MATCH(description) AGAINST ('SEARCHVARIABLE') group by score desc
SEARCHVARIABLE = Whatever you want it to, a word, or a passed variable.
Tony
Dreamweaver is the sharpest tool in my box!
|