List:General Discussion« Previous MessageNext Message »
From:Victor Pendleton Date:August 17 2004 1:13pm
Subject:RE: Full text for keyword(s) search?
View as plain text  
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: mysql@stripped
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/mysql?unsub=1
Thread
GUI for MySQLKirti S. Bajwa12 Aug
  • AW: GUI for MySQLFreddie Sorensen12 Aug
  • Re: GUI for MySQLKaram Chand13 Aug
  • Re: GUI for MySQLMartijn Tonies13 Aug
    • Full text for keyword(s) search?Eve Atley17 Aug
RE: GUI for MySQLGuillermo Chinchilla Zúñiga12 Aug
RE: Full text for keyword(s) search?Victor Pendleton17 Aug
  • Assistance with SQL syntax: pulling duplicates backEve Atley17 Aug
    • Re: Assistance with SQL syntax: pulling duplicates backMichael Stassen17 Aug
      • Re: Assistance with SQL syntax: pulling duplicates backMichael Stassen17 Aug
    • Re: Assistance with SQL syntax: pulling duplicates backSGreen17 Aug
RE: Assistance with SQL syntax: pulling duplicates backVictor Pendleton17 Aug
Re: Assistance with SQL syntax: pulling duplicates backMichael Stassen17 Aug