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.