Page 1 of 1

Need clarification on FullText information

Posted: Thu Dec 04, 2003 12:16 pm
by bnownlater
I am using SHOW INDEX on one of my tables that I have a FULLTEXT index on.

--------------------------------------------------------------------------------
Table: article
non_unique: 1
key_name: THEARTICLE
seq_in_index: 1
column_name: THEARTICLE
collation: A
Cardinality: NULL
sub_part: 1
packed: NULL
comment: FULLTEXT
--------------------------------------------------------------------------------

I read that sub_part means:
--------------------------------------------------------------------------------
The prefix length in bytes, if only a prefix of the column is indexed. This is NULL if the entire column is indexed.
--------------------------------------------------------------------------------

So is this telling me that my FULLTEXT index is only looking at the first byte of information. I thought that when you use FULLTEXt indexing it indexes the entire thing. Somebody please explain! Thanks.

Posted: Tue Dec 09, 2003 8:41 am
by kendall
bnownlater,

Well im not a MySQL guru but i have been using it and i have known FULLTEXT is a faster way in dealing with TEXTand BLOB search queries. I dont think the statement applies to that...you should check the mysql documentation for that.

Kendall