|
-
Jun 16th, 2002, 01:46 AM
#1
Thread Starter
Hyperactive Member
Setting a FULLTEXT index w/ PhpMyAdmin?
I don't see any place that would allow me to do this. I tried setting my "TEXT" field to be indexed, but it gave me an error because it didn't have a set length.
Any ideas?
Thanks
-
Jun 16th, 2002, 09:02 AM
#2
text fields cannot be indexed. only varchar and number fields.
-
Jun 16th, 2002, 10:49 AM
#3
Thread Starter
Hyperactive Member
Thanks, but that's not what it seems like according to MySql.com. I'm using a version later than 3.23.23+
From MySQL.com:
"As of Version 3.23.23, MySQL has support for full-text indexing and searching. Full-text indexes in MySQL are an index of type FULLTEXT. FULLTEXT indexes can be created from VARCHAR and TEXT columns at CREATE TABLE time or added later with ALTER TABLE or CREATE INDEX. For large datasets, it will be much faster to load your data into a table that has no FULLTEXT index, then create the index with ALTER TABLE (or CREATE INDEX). Loading data into a table that already has a FULLTEXT index will be slower.
Full-text searching is performed with the MATCH() function.
mysql> CREATE TABLE articles (
-> id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
-> title VARCHAR(200),
-> body TEXT,
-> FULLTEXT (title,body)
-> );
"
I have looked for the answer to my question in several places and I'm unable to find an answer. Any additional help would be appreciated.
-
Jun 16th, 2002, 12:25 PM
#4
well that explains why I can't have indexes on text fields. I run mysql 3.22.32
well if you run phpMyAdmin then you should be able to make a text field an index. mine won't as they are not linked.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|