现在我的语句是这样,排序很乱:
SELECT distinct product.id FROM product,price WHERE product.id=price.productid AND (product.productName like '%联想 BA1-6A%' or product.configure like '%联想 BA1-6A%' or product.productName like '%联想%' or product.configure like '%联想%' or product.productName like '%BA1-6A%' or product.configure like '%BA1-6A%') ORDER BY product.id DESC