Searching from Database with not matching two word

I want search all records with not matching two keyword (CLOS & CANS) like:

1. ADVG XCLT QRPR

2. ADVG CLOS QRPR

3. ADVG CLOS CANS

4. ADVG PQRS QRPR

from the 4 rows I want to display first and last rows. Rows having two word like CLOS and CANS shall not be display.

So, I want to know which keyword I shall use in query function. Not Includes function work only on keyword. But this query have more than one keyword. Please advice.

  Discussion posts and replies are publicly visible