题解 | #检索产品名称和描述(三)#
检索产品名称和描述(三)
https://www.nowcoder.com/practice/4302920bc3da44169a3ac458eb549d01
第一种做法:select prod_name,prod_desc from Products where prod_desc regexp 'toy' and locate('carrots',prod_desc) >0 第二种做法:select prod_name,prod_desc from Products where instr(prod_desc,'toy')>0 and prod_desc like '%carrots%'