Hi!
On Sep 15, [EMAIL PROTECTED] wrote:
> Hi list,
>
> I have a question that hopefully someone can help me with.
>
> We have a mysql database which contains 3000 records, and these records need
> to be searched.
>
> The table has 4 fields which need to be searched, so we created a full text
> index for the 4 fields. Now 1 of the fields contains dates, which we have
> formatted so that you would search for example for: 05 september 2001 and it
> needs to return all the results for this date. The problem is as we see it,
> is mysql has noisewords and the field with the datesearch has lots of records
> with the same date, and when we search it does not find the records, we need
> this to work, as otherwise it ruins the way we are producing this site.
>
> Has anyone any suggestions on this?
Two.
1. Move your date field out of FULLTEXT index.
2. See the manual, how to remove 50% threshold for fulltext search.
Regards,
Sergei
--
MySQL Development Team
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
<___/
---------------------------------------------------------------------
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