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: http://lists.mysql

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

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