Questions tagged [fulltext-index]
123 questions
0
votes
1 answer
MySQL Full text Search one is to many
Problem: I need to do a full text search on a field that has multiple rows (one to many).
I have these schema:
Company (15 MILLION+++)
-id
-companyname
Category
-companyid
-categoryname (W/ FULLTEXT INDEX)
Sample Data:
Company
id | companyname
1 …
john
- 93
- 9
0
votes
1 answer
Is really necessary to have two fulltext indexes for text columns?
I inherited the codebase for a custom CMS built with MySQL and PHP which uses fulltext indexes to search in content (text) fields. When analyzing the database structure I found that all relevant tables were created in the following fashion…
Proteo
- 11
- 4
0
votes
3 answers
Mysql, InnoDB to MyISAM for fulltext index
Actually, I would like to switch the engine of my tables. There are in InnoDB and I want to set them to MyISAM because of this
ALTER TABLE `xxx_db`.`yyy` ADD FULLTEXT `ft_modele` (
`anno_modele`
)
Error :
Documentation
#1214 - The used…
Raphaël
- 1,141
- 3
- 18
- 32