SELECT name FROM customer WHERE name LIKE 'W%ies' AND name NOT LIKE '%L%';
NAME
------------------------------
Worcester Technologies Wallace Industries

或者使用函数：

SELECT name FROM customer WHERE REGEXP_LIKE(name, '^W([^L]*)ies$');
NAME
------------------------------
Worcester Technologies Wallace Industries