MySQL Forums
Forum List  »  Full-Text Search

FULLTEXT Operaters
Posted by: M Karim
Date: July 14, 2006 06:03AM

I have installed MySQL 4.1 and created two tables, type (MyISAM Storage Engine)

TABLE1 has 200000 records
----------------------------------------
1st column:
----------------
Column name "item"
Datatype "INTEGER" "AUTOINCREMENT"
index name "PRIMARY"
index kind "PRIMARY"
index type "BTREE"

2nd column:
----------------
Column name "text"
Datatype "TEXT"
index name "text"
index kind "FULLTEXT"
index type "DEFAULT"

TABLE2 has 1000 records
------------------------------------
1st column:
----------------
Column name "item"
Datatype "INTEGER"
index name "item"
index kind "INDEX"
index type "BTREE"


I used INNER JOIN in MySQL Query as follows:

SELECT * FROM TABLE1 INNER JOIN TABLE2 ON TABLE1.item = TABLE2.item WHERE MATCH(TABLE1.text) AGAINST("keyword") LIMIT 0, 10;

ex:
SELECT * FROM TABLE1 INNER JOIN TABLE2 ON TABLE1.item = TABLE2.item WHERE MATCH(TABLE1.text) AGAINST("automobiler") LIMIT 0, 10
10 rows in set (0.00 sec)

But when I use operaters such as (*, +, - ... etc), it gives an empty set.

ex:
SELECT * FROM TABLE1 INNER JOIN TABLE2 ON TABLE1.item = TABLE2.item WHERE MATCH(TABLE1.text) AGAINST("automobil*") LIMIT 0, 10
Empty set (0.00 sec)

Also, it gives an empty set when using IN BOOLEAN MODE.

Then I installed MySQL 5.0, but unfortunately I didn't either work with operaters!!!

Is the FULLTEXT Syntax wrong??


Thanks in advance,

Best Regards,

Options: ReplyQuote


Subject
Views
Written By
Posted
FULLTEXT Operaters
3933
July 14, 2006 06:03AM


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.