MySQL ' where columnName not regexp '*'' clause doesn't work.

[zyh12]

It throws 'Encountered unexpected token: not' exception when parsing this clause. I tried v1.4, v2.1, v3.0, but nothing helped.

[wumpz]

Please provide a complete test sql.

[zyh12]

Please provide a complete test sql.

select * from t_test where c_test not regexp '[0-9]{18}|[0-9]{17}X|[0-9]{15}';