MySQL Forums
Forum List  »  Full-Text Search

Re: Full-Text search on single row fails
Posted by: Ventsislav Alexandriyski
Date: March 23, 2010 12:07PM

But if have table with just one row you cannot select it in this way.
In real job it may returns sometimes :)

If you want to select the word you should use IN BOOLEAN MODE

use this:

SELECT * FROM page WHERE MATCH (content) AGAINST ('valu*' IN BOOLEAN MODE);

-------------------------------Signature-----------------------------------------
http://www.nezavisim.com
I need job so if in your company there is need for optimizing and improving I am the man.
I can work from home via internet. Results are always best

I can complete all tasks from idea to final product, handling hardware desing, programming, installing and configuring all required hadrware and software.
And what can you?

Forum Moderators delete my posts so I cannot write delailed explanations, becaue this will be waste of time when my post is deleted by motherators



Edited 1 time(s). Last edit at 03/23/2010 12:34PM by Ventsislav Alexandriyski.

Options: ReplyQuote


Subject
Views
Written By
Posted
5677
March 15, 2010 02:46AM
Re: Full-Text search on single row fails
2334
March 23, 2010 12:07PM


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.