题解 | #检索产品名称和描述（三）#

第一种做法：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%'