sql select with does not contain

oracle, sql

Solution

Should be:

select MY_ID, JOB_ID
from MY_TABLE
where JOB_ID not like 'bra%'
and JOB_ID not like 'wes%'
and STS_DTTM < trunc (sysdate) - 12;

And the column name should be job_name or job_code, not Job_id. Job_id sounds like a number :)

Problem

This is my select: ``` select MY_ID, JOB_ID from MY_TABLE where JOB_ID != 'bra%' and JOB_ID != 'wes%' and STS_DTTM < trunc (sysdate) -12 ``` It still selects fields with values that contain "bra" and "wes" Thank you & regards,

Original source