题解 | #检索产品名称和描述(三)#
检索产品名称和描述(三)
https://www.nowcoder.com/practice/4302920bc3da44169a3ac458eb549d01
本题思路较为清晰,要使prod_desc中同时包含"toy","carrots",题目又提示使用两个like 和 and,那么代码就较为好写
select prod_name,prod_desc from Products where prod_desc like "%toy%" and prod_desc like "%carrots%"

