Here's the query I'm using:
Code: Select all
$query2="SELECT * , MATCH(`data`, `keydate`) AGAINST('$q') AS score
FROM `dataindex` WHERE `userid`='$userid' AND MATCH(`data`, `keydate`) AGAINST('$q') ORDER BY score DESC ";Code: Select all
$query2="SELECT * , MATCH(`data`, `keydate`) AGAINST('$q') AS score
FROM `dataindex`ORDER BY score DESC ";I have the FULL TEXT index setup in the db on the columns data and keydate.
Cheers, Hope someone can help
Joe