Search contacts

We have created a contact field we called keywords. It is a text field. We need to search the contacts to create mailing list based on that field using “not” operator (namely “keyword not equal to colorado”). I’m sure this is very do-able, but after several days of searching and trying different things, I am no closer. Any help would be appreciated, thank you. -tbh

link at the post. You can write SQL query for each field.