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
2967
July 10, 2014 12:15PM
1712
July 13, 2014 04:50PM
1407
July 14, 2014 10:19AM
1593
July 14, 2014 10:23AM
1500
July 14, 2014 11:16AM
Re: Select * vs Select Columns
1472
July 14, 2014 11:20AM
1547
July 14, 2014 01:37PM
1496
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.