题解 | #检索产品名称和描述(二)#
检索产品名称和描述(二)
https://www.nowcoder.com/practice/669913837a7648f9aa0caaf6a88c834f
在like关键字查询前添加not
在REGEXP 正则匹配前添加not
select prod_name, prod_desc from Products where prod_desc not REGEXP 'toy' # where prod_desc not like '%toy%' order by prod_name asc