题解 | 检索产品名称和描述(三)(instr)
检索产品名称和描述(三)
https://www.nowcoder.com/practice/4302920bc3da44169a3ac458eb549d01
select * from Products
where prod_desc like '%toy%'
and prod_desc like '%carrots%'
也可以用instr函数:
select * from Products
where instr(prod_desc, 'toy') > 0
and instr(prod_desc, 'carrots') > 0