If you are using MyISAM tables you can create a fulltext index. This index should give you better performance over a wildcarded like search provided that no more than fifty percent of your rows do not contain the word or words you will be searching for.
-----Original Message----- From: Eve Atley To: [EMAIL PROTECTED] Sent: 8/16/04 7:18 PM Subject: Full text for keyword(s) search? If I want to search for a word (or multiple words) in a field on one table, searching through at least a thousand records (and growing daily), should I be using full text or something else to make this search faster? I'm using MySQL 3.23.58. Thanks, Eve -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
