- Dathan Vance Pattishall
- Sr. Programmer and mySQL DBA for FriendFinder Inc.
- http://friendfinder.com/go/p40688
-->-----Original Message-----
-->From: michael.hendry@stripped [mailto:michael.hendry@stripped]
-->Sent: Wednesday, October 15, 2003 8:09 AM
-->To: mysql@stripped
-->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/mysql?unsub=1
