mysql - SQL 选择一条语句期望值以

Question

我这里有以下代码:

SELECT productcode, Brand, product, size
from outerbarcodes i
where productcode = '' or productcode is null or
     brand = '' or brand is null or
     product = '' or product is null or
     size = '' or size is null;

我想添加一个条件，不在产品代码列中包含以 'PK' 开头的值。代码将如何修改？

提前致谢

Answer 1

您可以在当前的 where 子句中添加一个 LIKE 条件:

SELECT productcode, Brand, product, size
FROM outerbarcodes i
WHERE
    (productcode > '' AND productcode NOT LIKE 'PK%') OR
    brand > '' OR
    product > '' OR
    size > '';