select * from Products
where prod_desc regexp 'toy'
and prod_desc regexp 'carrots'

虽然说要用两个like，但发现这样也能过。