- Dathan Vance Pattishall - Sr. Programmer and mySQL DBA for FriendFinder Inc. - http://friendfinder.com/go/p40688
-->-----Original Message----- -->From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] -->Sent: Wednesday, October 15, 2003 8:09 AM -->To: [EMAIL PROTECTED] -->Subject: Fulltext vs Pattern Matching? --> -->Hello: --> -->I want to provide free text searching on my database across numerous -->fields. -->The question is, is it better to use a freetext field, or pattern -->matching and -->or-ing the fields I want to search. Or-ing across multiple columns will not be done on a key lookup even if you have a compound across said columns. --> -->What scares me off of Freetext is that I only have about 40 records, they -->all -->relate to a specialized community, so it is quite possible that a search -->term -->could return more than 50% of the records. What is Freetext? --> -->I'm using v3.23.27, which has fulltext, and cannot upgrade. Why? Did you add specialized code to that version of mySQL? --> -->I would appreciate any thoughts you have on this, or a pointer to a -->thread if -->this has already been discussed. --> -->Many Thanks! -->Mike --> --> -->-- -->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]
