how to check string does not contain another string similar to postgresql code example

Example: postgresql contains

SELECT id FROM TAG_TABLE WHERE 'aaaaaaaa' LIKE '%' || tag_name || '%';