I have only ever used LIKE and when doing so, you need to surround the value/variable with '%these jobbies%'
Say for example you want to find a word that is like 'sday', well to find those which end in 'sday' you would use '%sday' so you would get back Tuesday, Wednesday Thursday.
And if you want to find words beginning with 'Mon%', the % goes at the end, where #mon' would join with 'ney' or 'day' giving money and monday, for example.
from table where col_name like '%sday'
I imagine that not like would work similarly so give it a try, if you like.