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.
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. I'm using v3.23.27, which has fulltext, and cannot upgrade. 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]
