Where statement to NOT rlike
I am trying to exclude by using the NOT rlike and it does not seem to exclude as I want it. Am I doing something wrong?
and HD_TICKET.CUSTOM_FIELD_VALUE0 NOT RLIKE ('HP Records Manager (HP RM)|Bar Code Reader TRIM|Intranet|Internet Site|Project Development Reg (PDR)')
and HD_CATEGORY.id rlike ('43|44|46|47|60|69') and HD_TICKET.HD_QUEUE_ID = 2