Fulltext vs Pattern Matching?

2003-10-15 Thread michael.hendry
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

RE: Fulltext vs Pattern Matching?

2003-10-15 Thread Dathan Vance Pattishall
- 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

Re: Fulltext vs Pattern Matching?

2003-10-15 Thread Roger Baklund
* Mike 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

Re: Fulltext vs Pattern Matching?-Solved

2003-10-15 Thread Michael Hendry
Roger: Thank you for your reply, it is right on the money. I will try pattern matching first and see how that works. I don't mind the extra programming, and I don't expect our user base to grow significantly. Thanks again Mike -- MySQL General Mailing List For list archives: