MySQL and multiple likes

[filburt1]

Observe:

PHP Code:

$result = $DB_site->query("SELECT userid, username, vbms_alias,
        IF(options & " . $_USEROPTIONS['emailonpm'] . ", 1, 0) AS emailonpm
        FROM " . TABLE_PREFIX . "user
        WHERE vbms_alias != \"\" AND LCASE(vbms_alias) NOT IN ($bannedaliases)"); 


Note the NOT IN portion. I want to match against a series of LIKE matches ("%alias1%", "%alias2%", etc.). I can figure out how to match against a single alias with LIKE or a group of aliases exactly with IN, but not both. Ideas?