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
2916
July 10, 2014 12:15PM
1649
July 13, 2014 04:50PM
1368
July 14, 2014 10:19AM
1569
July 14, 2014 10:23AM
1476
July 14, 2014 11:16AM
Re: Select * vs Select Columns
1436
July 14, 2014 11:20AM
1515
July 14, 2014 01:37PM
1473
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.