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
2844
July 10, 2014 12:15PM
1574
July 13, 2014 04:50PM
1325
July 14, 2014 10:19AM
1529
July 14, 2014 10:23AM
1439
July 14, 2014 11:16AM
Re: Select * vs Select Columns
1388
July 14, 2014 11:20AM
1470
July 14, 2014 01:37PM
1431
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.