题解 | #检索产品名称和描述（三）#
检索产品名称和描述（三）
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%'
查看8道真题和解析