RegEx not containing a string

[Heinrich Ruoff]

Hello to all,

can anyone help me how to exclude a string in a regex?

e.g. find all records where name contains "Smith" but doesn't contain "John"
SELECT * from tb_persons WHERE name REGEX 'Smith !John'

thanks
Heinrich