mysql fulltext search as level2 index
- by Nir
lets say I have a table with product details. one of the fields is category (integer).
I want to do fulltext search on product name in specific category.
Unfortunately Mysql does not allow me to specify index that includes category and product name as fulltext. It looks like I can use fulltext only on product_name and theefore any fulltext search will search product names in all categories.
Is there any way to solve this (allow fulltext search/index only on products in category)?