Thanks for the feedback, I surely appreciate it.
I asked the pattern match question, because I am using a hosting service that hosts MySQL 3.23. Since I have a need to search on terms less than 3 characters long and I can not re-compile, I was looking for another solution. I thought that I might be able to use pattern matching as a substitute, but it sounds like performance might be an issue with large tables.
If you have any other recommendations on how I could approach my problem, I would surely appreciate them.
At 07:35 AM 12/31/02 -0800, Qunfeng Dong wrote:
It can perform pattern match on text field. The only draw back is the speed (especially if you are using %pattern% to do the search) when you tables are getting huge, since there is no index to help.Qunfeng --- Frank Peavy <[EMAIL PROTECTED]> wrote: > I would like to use pattern matching as a substitute > to fulltext search on > MySQL 3.23. > Is this a good alternative? > > Are there any limits, like not being able to perform > a pattern match on a > 'text' field, etc., that I need to be aware of? > > Thanks. > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list > archive) > > To request this thread, e-mail > <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: > http://lists.mysql.com/php/unsubscribe.php > __________________________________________________ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
