oracle - sql select with does not contain -

this select:

select my_id, job_id my_table job_id != 'bra%' , job_id != 'wes%' , sts_dttm < trunc (sysdate) -12 

it still selects fields values contain "bra" , "wes"

thank & regards,

should be:

select my_id, job_id my_table job_id not 'bra%' , job_id not 'wes%' , sts_dttm < trunc (sysdate) - 12; 

and column name should job_name or job_code, not job_id. job_id sounds number :)