How to do a query with two conditions?

[Phire]

SELECT column1,column2 FROM atable WHERE acolumn1 NOT LIKE '%blah%' AND NOT column2 = 'john doe'

The query will not select the row if either "NOT LIKE blah" or if column2 = john doe. I need it to check both conditions simultaneously. Meaning, if acolumn1 is "abcd" and column2 is john doe, it will select the row.

[bradgrafelman]

Change the 'AND' to an 'OR' in the condition.