题解 | #检索产品名称和描述(一)#
检索产品名称和描述(一)
https://www.nowcoder.com/practice/47e8101cb2b447038effcf5159e6aa7f
# select p.prod_name,p.prod_desc # from Products as p # where p.prod_desc like '%toy'; select p.prod_name,p.prod_desc from Products as p where p.prod_desc like '%toy%';
要严谨,不能题目中给出字符后半段有toy就不管前面有toy的情况