mysql 如何反向like

SELECT * FROM table_name WHERE column_name NOT LIKE '%pattern%';

SELECT * FROM table_name WHERE column_name NOT REGEXP '.*pattern.*';

SELECT * FROM table_name WHERE column_name NOT IN (
    SELECT column_name FROM table_name WHERE column_name LIKE '%pattern%'
);

-- 使用 NOT LIKE
SELECT * FROM users WHERE username NOT LIKE '%admin%';

-- 使用 NOT REGEXP
SELECT * FROM users WHERE username NOT REGEXP '.*admin.*';

-- 使用 NOT IN 结合子查询
SELECT * FROM users WHERE username NOT IN (
    SELECT username FROM users WHERE username LIKE '%admin%'
);