MySQL Forums
Forum List  »  Full-Text Search

Don't show similar words
Posted by: Waldemar Axdorph
Date: July 22, 2008 06:23AM

Hi!

I have a table with similar words from search queries.

SELECT query FROM search
apple
aple
aplle
orange
pear

I want this to be my output but I don't know how to do it.

apple
orange
pear

I thought that you do something like,
SELECT MATCH(query) AGAINST (query WITH QUERY EXPANSION
) FROM open_search_stats_query WHERE MATCH
(query) AGAINST(query WITH QUERY EXPANSION
)

but that gives me an error: #1210 - Incorrect arguments to AGAINST
Can you please help me?

Thank you in advance,
Waldemar



Edited 1 time(s). Last edit at 07/22/2008 06:24AM by Waldemar Axdorph.

Options: ReplyQuote


Subject
Views
Written By
Posted
Don't show similar words
4496
July 22, 2008 06:23AM


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.