i have 2 tables 'product' and 'product_features' . products table has name and description while product features has the product's code and attribute I have created an individual FULLTEXT search for name, description and attribute.
i am trying to do a search that returns the results from the products table based on searches from both the products and the products_features table but i am having a hard time writing the query string
this is what i have so far
Turns out sort of ok but i want to really bring out the results of the product code based on theSELECT * FROM product, features WHERE MATCH(name) AGAINST('magnum, television, screen') OR MATCH(description) AGAINST('magnum, television, screen') AND MATCH(attribute) AGAINST('magnu, television, screen') GROUP BY features.code
AND MATCH(attribute) AGAINST('magnu, television, screen') GROUP BY features.code
Am i going to far fetched here?
Kendall