MX Site Search Forum :: search part of a word

This thread was displayed: 0 times


Starting with 17th May 2007, Adobe Systems will stop offering support for any version of the discontinued InterAKT products. As a result, we will not answer to new support incidents starting with May 17th, 2007. Pending support incidents will still be followed in order to be closed. The product forums will remain open and be transformed in user-to-user forums. The general forums will be made read-only and not allow new posts or comments.

For more information about the affected products visit: www.interaktonline.com/Support/

View Threaded Show descending
Phil Brook
03-12-2007 13:37:54 GMT +2

Searching for part of a word isn't working.

i.e. searching for..  distinct    ..should find the word...  distinctive

but it isn't doing this, what am I doing wrong?

I notice this has been asked before but couldn't find an answer...
I have tested both on my local test server and on a live test site

Regards

Phil

Back | Reply | Quote | Top
Razvan Racasanu[InterAKT]Adobe Systems Romania staff
03-12-2007 14:02:57 GMT +2

Hello,

Can you tell me what database and server model are you using (PHP, ASP, CF)? Also, what have you selected from the "Indexing type" drop-down?

Regards,
Razvan RACASANU

Reply | Quote | Top
Phil Brook
03-12-2007 14:27:05 GMT +2

Hi,

I am using php/mysql and have tried it with both "fulltext" and "boolean fulltext" (mysql is later than version 4...)

Regards

Phil

Reply | Quote | Top
Razvan Racasanu[InterAKT]Adobe Systems Romania staff
03-12-2007 14:41:05 GMT +2

Hello,

In boolean fulltext you can use the "*" operator for prefix matching. For more information on this and available operators, please read this page from the MySQL documentation.

Regards,
Razvan RACASANU

Reply | Quote | Top
Phil Brook
03-12-2007 14:56:51 GMT +2

thanks for your prompt replies Razvan, so does this mean that the user must type *

or could I alter my mx_site_search to automatically add * before and after every word?

Kind Regards

Phil

Reply | Quote | Top
Razvan Racasanu[InterAKT]Adobe Systems Romania staff
03-12-2007 15:03:47 GMT +2

Hello,

No, the user will have to specify that it wants a prefix search so he must enter it.

Regards,
Razvan RACASANU

Reply | Quote | Top
Phil Brook
03-12-2007 18:03:44 GMT +2

Hi Razvan,

I want to make the search as simple for the user as poss, therefore would there be an easy way for me to simply add the * to the end of the string by altering/tweaking something in the include files? This way if someone only types one word they have more chance of decent results rather than only exact matches. Unfortunately, this is the only thing which is preventing me from being able to use mx_site_search as at the moment my client's existing basic frontpage keyword search appears to be working more effectively.

Regards

Phil

Reply | Quote | Top
Razvan Racasanu[InterAKT]Adobe Systems Romania staff
03-13-2007 12:07:49 GMT +2

Hello,

No, it is not very easy to do so, because multiple words must also be considered which complicates things as the * must be added after each one.

Regards,
Razvan RACASANU

Reply | Quote | Top
MX Site Search 1.8.0
© Adobe Systems Romania. All rights reserved.