Like模糊查询:
SELECT
*
FROM
table
WHERE username NOT LIKE '%测试%'
AND username NOT LIKE '%ceshi%'
AND username NOT LIKE '%tester%'
;
正则匹配:
SELECT
*
FROM
table
WHERE username NOT REGEXP '测试|ceshi|tester'
;
Like模糊查询:
SELECT
*
FROM
table
WHERE username NOT LIKE '%测试%'
AND username NOT LIKE '%ceshi%'
AND username NOT LIKE '%tester%'
;
正则匹配:
SELECT
*
FROM
table
WHERE username NOT REGEXP '测试|ceshi|tester'
;