Search Multipe Fields, Compounding Fields, Like, Contains...?

I would like to search a table for a phrase, or for a partial phrase,
eg on table product - for name or description, or name + descprition.

How does one say select * from product where name + description like
%phrase%
or contains phrase

Currently I can get where name, or where descriotion like %phrase%,
eg, where name like krups, or where description like coffee maker

But if I search for where name like %krups coffee maker% i get no
results. krups is in the name field, coffee maker is in the
description field.

Thanks,
-M