Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

FULL TEXT search with Partial Matching results

Status
Not open for further replies.

bdichiara

Programmer
Oct 11, 2006
206
US
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)
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.
 
Sorry, what I meant was, if I search for "prod", it doesn't pull up the results containing "product"

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

_______________
_brian.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top