MySQL Forums
Forum List  »  MyISAM

FullText Search - Substring match, possible?
Posted by: Saurabh Arora
Date: January 21, 2012 05:45AM

Hi

I am using fulltext searches as search mechanism on an application, I would like to make user experience better, Following 2 steps can make a huge difference.

1.
The user should be able to search sub-strings.
e.g. a model-> Sony WT13i.

Present case -> if a user types wt, he/she can see the results(which includes wt13i)
But if a user types 13i, nothing is returned in the result set.
I wanna show user WT13i even when 13i is typed and searched.

How to implement it optimally?

2.
I do not have a mechanism of ordering the results, from a db/table, according to relevance. i.e results which have +A +B should come before results which have A or in them, A and B being the searched strings.

what is the best practice to order the results, in big databases, which have >50000 rows.

Thanks,
Saurabh.


P.S - i recently changed ft_min_word_len=2, i love how things have improved. Should i beware of any of its disadvantages?



Edited 2 time(s). Last edit at 01/21/2012 05:47AM by Saurabh Arora.

Options: ReplyQuote


Subject
Views
Written By
Posted
FullText Search - Substring match, possible?
5861
January 21, 2012 05:45AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.