mysql - 正则表达式无效字符长度

Question

这个 MySQL 查询有效:

SELECT p.slug FROM products AS p
WHERE p.slug REGEXP '[^a-zA-Z0-9_-]'

但是这个不行:

SELECT p.slug FROM products AS p
WHERE p.slug REGEXP '[^a-zA-Z0-9_-(]'

这两个都不行:

SELECT p.slug FROM products AS p
WHERE p.slug REGEXP '[^a-zA-Z0-9_-\(]'

Answer 1

你需要使用 \\ 来转义那个特殊字符

SELECT p.slug FROM products AS p WHERE p.slug REGEXP '[^a-zA-Z0-9_-\\(]'

引用请阅读 doc

EDIT: use \\ to escape any special character in your expression. like in above query - is special character.