如何在MySQL中使用正则表达式? [英] How to use regex in MySQL?

问题描述

我想用field not like '%_[0-9]+'过滤掉那些

但是事实证明MySQL并没有将其当作正则表达式，

but it turns out that MySQL doesn't take it as regex,

在MySQL中有可能吗?

is that possible in MySQL?

推荐答案

发生这种情况是因为LIKE不应该接受正则表达式作为参数.有 REGEXP 这样的东西

That happens because of LIKE is not supposed to accept regular expression as a parameter. There is REGEXP for such things

WHERE field NOT REGEXP '%_[0-9]+'

这篇关于如何在MySQL中使用正则表达式?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！