I understand the idea behind "FULL TEXT" searching, however is it possible to get partial matching results with maybe a lower relevance. Here's one of my sample queries:
(note: $like is my [cleaned up] PHP search term variable)
The problem with this is it only gives solid results. So if I searched for "product" and my plain_content field held "product/service", my item doesn't show up.
Any ideas?
_______________
_brian.
(note: $like is my [cleaned up] PHP search term variable)
Code:
SELECT *, MATCH(description,url,filename,plain_content) AGAINST ('$like') AS relevance FROM links WHERE MATCH(description,url,filename,plain_content) AGAINST ('$like') AND deleted <> '1'
The problem with this is it only gives solid results. So if I searched for "product" and my plain_content field held "product/service", my item doesn't show up.
Any ideas?
_______________
_brian.