How does the search feature work?

albatroz · Post by **albatroz** » Mon Jul 14, 2003 4:12 am

I am having a problem with the search feature.

It seems it is not working fine, because I don't receive any record
when I start a search. What fields does the SEARCH look into?

Post by **Thorsten** » Mon Jul 14, 2003 7:03 am

Hi,

just take a look in our documentation:

Fulltext-search will only work if there are some entries in the database (5 or more). The term you are looking for should also not be in more than 50% of all your entries, or it will automatically be excluded from search. This is not a bug, but rather a feature of MySQL.

You only have 2 entries, so the fulltext-search isn't working yet.

bye
Thorsten

filemaniac · Post by **filemaniac** » Tue Aug 05, 2003 6:24 pm

Full-text search can be more than a little annoying, especially when you intend some entries to be somewhat alike or about the same topic. Is there a way to force it to just look at keywords?

Post by **Thorsten** » Tue Aug 05, 2003 10:00 pm

Hi,

filemaniac wrote:Is there a way to force it to just look at keywords?

yes, but you have to change something in the MySQL table:

Code: Select all

ALTER TABLE <prefix>faqdata DROP INDEX keywords
ALTER TABLE <prefix>faqdata ADD FULLTEXT (keywords)

bye
Thorsten