FULL TEXT search with Partial Matching results

[bdichiara]

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)

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.

 

[bdichiara]

Sorry, what I meant was, if I search for "prod", it doesn't pull up the results containing "product"

_______________
_brian.

 

[bdichiara]

Ok, I figured this out, I'm using IN BOOLEAN MODE and surrounding the search with * characters. that did the trick

_______________
_brian.