I wanna use match against for sorting relevance, and searching the records. But i need the some reccords to be found as well, thats not found atm.
When a user searches for 'car', it needs to find 'carwheels' and 'carphone' as well. And 'car' with higher relevance.
Din't check the query, but it's something like this.
Code: Select all
SELECT
`items`.*,
MATCH (`title`,`description`) AGAINST ('car') AS `rel`
FROM `items`
WHERE
MATCH (`title`,`description`) AGAINST ('car')
ORDER BY `rel` DESCAnd AGAINST ('car%') doesn't seem to work.