By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,433 Members | 776 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,433 IT Pros & Developers. It's quick & easy.

full-text search mysql

P: n/a

I building a little site using PHP and mysql. Now I want to make full
text searches on some columns in one table. The problem is that I have
25 colums in the table that I want to put at full-text index on. I
belive there is a limitation of 14(?) colums. What is the proper way
to handle this?

Reading about full-text indexes, do I have to make a "repair table..."
after each time I insert data in the table the will be included in the
indexed columns? If this is the case I must repair the table every
time I insert anything?!

I am using "DBDesigner 4". How can I see in my table that it is a
full-text index. Seems like it appears as a normal index in my data
definition as well as in the reversed engineered graphical


Jul 17 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.