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
5486
July 10, 2014 12:15PM
2782
July 13, 2014 04:50PM
2055
July 14, 2014 10:19AM
2171
July 14, 2014 10:23AM
2260
July 14, 2014 11:16AM
Re: Select * vs Select Columns
2152
July 14, 2014 11:20AM
2220
July 14, 2014 01:37PM
2084
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.