> I managed to index and change all queries to use AGAINST and
> etc. but the users didn't like it. They say they really need
> the functioning of '%text%'.
Isn't it rather 'text%' ? This '%text%' you have without FULLTEXT
feature - in fact you have been using it before. Note that google
uses the same functionality, and for the same reasons MySQL
offers on http://www.mysql.com/doc/F/u/Fulltext_Search.html
"A word that matches half of rows in a table is less likely to
locate relevant documents. In fact, it will most likely find
plenty of irrelevant documents. We all know this happens far too
often when we are trying to find something on the Internet with a
search engine. It is with this reasoning that such rows have been
assigned a low semantical value in this particular dataset. "
> Sending 'protect' from the app they want to receive:
> 1) 'the protection'
> 2) 'protecting the whales'
> 3) 'please protect me'
--
Herzlich
Werner Stuerenburg
_________________________________________________
ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen
Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409
http://pferdezeitung.de
---------------------------------------------------------------------
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
