Full Text Search

[Stelios Theodoridis]

Hi everybody,

I am trying to play around with full text search, however it doesnt seem to be working on my machine. I have got 3.23.54 mysql version and a test table with some data in it mainly containing the word 'test'. I have altered the table and added the full text capability to the columns and I am trying to run a query such as:

SELECT * FROM table WHERE MATCH(title, body) AGAINST ('test');

I am getting back a result that says : Empty Set.

How is this possible? I know that my mysql version supports Full text. Could anybody please help me?

Thanks a lot!