And, alas, by the time MySQL finishes building my 500 MB fulltext index (more than 12 hours) the table is throroughly corrupted, and myisamchk can't even recover it with -o.
I'm waiting for 4.01 to go beta, and will then give it a try to see if things are happier there. Tom Haapanen [EMAIL PROTECTED] -----Original Message----- From: Steve Rapaport [mailto:[EMAIL PROTECTED]] Sent: 03 January 2002 04:39 To: Neil Tompkins Cc: [EMAIL PROTECTED] Subject: Re: Full Search Yes, you can add a FULLTEXT index to that table including all 15 fields, e.g. CREATE FULLTEXT INDEX findtext ON mytable (field1, field2, field3,...field15); Caveats: The fields must be of type VARCHAR or TEXT to work, (CHAR can be changed to VARCHAR easily, and often is silently changed.) Depending on the table size and other things, creating this index can be very slow, taking hours or even days. Try in advance to limit the size and number of fields in the index to what you really want, and don't plan on re-indexing very often. Steve. Neil Tompkins wrote: > I have a mySQL table which has about 15 fields. Is it possible using a > standard SQL statement to do a full text search on all fields ?? -- Steve Rapaport World Citizen --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
