Forum Moderators: open
Currently im using MySQL's full text functionality to search for records in my database. I have one quick question though. How would I configure it so that I could search for partial expressions.
Example. Say I search for 'print', I would get results returned when words such as 'printers, printing, prints etc' are found.
someone recommand me the"with Query Expansion", from
[dev.mysql.com ]
the fact that this interesting feature could be dangerous. It' s very simple to increase the number of matching rows close to the total number of rows of the table; such a search have no meaning.
So i need someone to give me better advice to solve the problem.
Have you find out how to solve your problem? if do so,please tell me.
[mysql.org...]
*The asterisk serves as the truncation (or wildcard) operator. Unlike the other operators, it should be appended to the word to be affected. Words match if they begin with the word preceding the * operator.
So you would do something like
... MATCH (myfield) AGAINST ('print*' IN BOOLEAN MODE)
For the "QUERY EXPANSION", which from [mysql.org ], it say it can deal with the following problem;
it could be searching for books by Georges Simenon about Maigret, when a user is not sure how to
spell “Maigret”. A search for “Megre and the reluctant witnesses” finds only “Maigret and the Reluctant
Witnesses” without query expansion. A search with query expansion finds all books with the word “Maigret”
on the second pass.
but when i run the code, it having nothing happen, bring me the 0 records.
i change the database to databaze.
SELECT * FROM articles
WHERE MATCH (title,body)
AGAINST ('databaze' WITH QUERY EXPANSION);
Could you tell me why? Thanks
