SELECT DISTINCT
productname
FROM
(
SELECT
miulee.ranking,
miulee.BSRDate,
miuleesku.productname,
miuleesku.Bigcategoryname
FROM
miulee
INNER JOIN miuleesku ON miulee.asin = miuleesku.asin
) miuleedeal WHERE productname NOT REGEXP '毛|天鹅绒|簇绒|防水|户外' AND Bigcategoryname='抱枕套'
ORDER BY
BSRDate
方向正则匹配主要使用的是NOT REGEXP,REGEXP进行正向匹配