用这个::
SELECt * FROM MyTable WHERe (Column1 LIKE '%keyword1%' OR Column2 LIKE '%keyword1%') AND (Column1 LIKE '%keyword2%' OR Column2 LIKE '%keyword2%');

用这个::
SELECt * FROM MyTable WHERe (Column1 LIKE '%keyword1%' OR Column2 LIKE '%keyword1%') AND (Column1 LIKE '%keyword2%' OR Column2 LIKE '%keyword2%');