Need clarification on FullText information

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
bnownlater
Forum Newbie
Posts: 4
Joined: Thu Jan 02, 2003 2:22 pm
Location: Orlando, FL

Need clarification on FullText information

Post 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.
User avatar
kendall
Forum Regular
Posts: 852
Joined: Tue Jul 30, 2002 10:21 am
Location: Trinidad, West Indies
Contact:

Post 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
Post Reply