高效的SQL，用于选择带有关键字的列，但同时排除另一个单词

I want to search from a table that includes certain keyword but at the same time the resulting records should not contain another word.I want to search from a table that includes cer