题解 | #检索产品名称和描述（三）#
检索产品名称和描述（三）
https://www.nowcoder.com/practice/4302920bc3da44169a3ac458eb549d01
select prod_name, prod_desc from Products where prod_desc like "%carrots%toy%"
select prod_name,prod_desc
from Products
# where prod_desc like '%toy%'and prod_desc like '%carrots%';#行
# where prod_desc like '%toy%'and '%carrots%';不行
where prod_desc like '%carrots%toy%';#行
# where prod_desc like '%toy%carrots%';不行
查看11道真题和解析
，那不应该啊，我就这一个基本上收到不少面试了
