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
