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?
Many thanks
barry
---------------------------------------------------------------------
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