MySQL Forums
Forum List  »  Full-Text Search

Re: Select * vs Select Columns
Posted by: Lee Fairbanks
Date: July 14, 2014 11:20AM

EXPLAIN EXTENDED
SELECT P.product_id, P.product_merchant_product_id, P.product_name, P.product_description, P.product_on_web, P.product_archive, P.product_keywords, P.product_best_seller, P.product_featured, P.product_usa, P.product_intro, P.age_from, P.age_to, P.grade_from, P.grade_to, S.sku_id, S.sku_merchant_sku_id, S.sku_product_id, S.sku_price FROM cw_products P INNER JOIN cw_skus S ON P.product_id = S.sku_product_id WHERE ( P.product_archive <> True AND P.product_merchant_product_id LIKE 'tree') OR (MATCH (P.product_name) AGAINST ('tree' IN NATURAL LANGUAGE MODE) AND P.product_archive <> True ) OR (MATCH (P.product_description) AGAINST ('tree' IN NATURAL LANGUAGE MODE) AND P.product_archive <> True)

Options: ReplyQuote


Subject
Views
Written By
Posted
5119
July 10, 2014 12:15PM
2485
July 13, 2014 04:50PM
1873
July 14, 2014 10:19AM
1976
July 14, 2014 10:23AM
1914
July 14, 2014 11:16AM
Re: Select * vs Select Columns
1940
July 14, 2014 11:20AM
1998
July 14, 2014 01:37PM
1892
July 15, 2014 09:27PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.