Results 1 to 3 of 3
Jul 23, 2003, 06:11 #1
Full text indexing in MYSQL table
ALTER TABLE `tickets` ADD FULLTEXT FULLTEXT (problemWith,issue,fix)
This code isn't working. I want to build a FULLTEXT index in my table called "tickets" and look through 'problemWith', 'issue', and 'fix' fields for search functionality. I get a MYSQL error. This table is already created, so I'm just trying to add this index now, which is why I used the ALTER TABLE command. All 'problemWith' is a varchar field, while, 'issue' and 'fix' are text fields. Any ideas of what I've done wrong?
Jul 23, 2003, 20:20 #2
- Join Date
- Oct 2002
- Toronto, ON
- 0 Post(s)
- 0 Thread(s)
you have two "FULLTEXT"s...
ALTER TABLE `tickets` ADD FULLTEXT (problemWith,issue,fix)
Jul 24, 2003, 05:30 #3
Yeah, I figured it out. I was using MySQL-Front, which prompts you for a name when you create an index, but you need to keep it blank I guess. Thanks.