按先后顺序同时出现toy和carrots

select 
    prod_name, prod_desc 
from 
    Products
where
    prod_desc like '%toy%carrots%';

在like中控制字段的顺序