Hi All,
I'm currently engaged in a project to implement full text searching
of our product database. The current implementation was written for an
older version of MySQL and doesn't implement BOOLEAN MODE.
Currently, the full text search is against a de-normalised table from
fields icluding the
Keep in mind that if you create an index on multiple
fields, then all of those fields must be searched at
once. You can't index product_name, product_desc and
product_category for instance, then only search on the
product_name field using MATCHES.
If you want to bypass this (and many other