Results 1 to 6 of 6
Feb 27, 2002, 11:04 #1
- Join Date
- Jan 2002
- 0 Post(s)
- 0 Thread(s)
Need help with MySQL fulltext indexes
I'll start out with my table structure (simplified):
CREATE TABLE messages ( id MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT, subject VARCHAR(100) DEFAULT NULL, message TEXT, PRIMARY KEY( id ), );
FULLTEXT KEY subject (subject),
FULLTEXT KEY message (message),
FULLTEXT KEY both (subject,message)
I believe I have to add indexes like above. The main question. How would I then search this messages table?
BTW. Can I use wildcard searches in fulltext indexed fields?