Big Query Display result for data's that does not contain certain words

Question

I have a big query data which contains 2 columns, MyText and SenderID. The tablename is mydatatable. I managed to filter the message list of rows that contain the word PIN or CODE in the MyText table id.

This was done like this:

SELECT * 
FROM `mydatatable` 
WHERE Mytext LIKE '%PIN%' OR Mytext LIKE '%CODE%'

How do we display the list of rows that do not contain the word "PIN" or "CODE"?

Thanks

Answer 1

SELECT * FROM mydatatable WHERE NOT (Mytext LIKE '%PIN%' OR Mytext LIKE '%CODE%')