Mysql在正则表达式上抛出异常 [英] Mysql throwing exception on Regex

问题描述

这有效:

mysql> SELECT '123456789' REGEXP '.{3}';#1

mysql> SELECT '123456789' REGEXP '.{10}';#2

但不是这个:

mysql> SELECT * FROM mymodel WHERE some_text_field REGEXP '.{100}';#3

抛出异常:错误 1139 (42000):来自正则表达式的错误无效重复计数"

throwing exception: ERROR 1139 (42000): Got error 'invalid repetition count(s)' from regexp

推荐答案

这意味着您在此字段中没有包含 100 个或更多字符的字符串.
如果你只是想检查这个条件，你可以试试这个:

It means you don't have a string which is 100 characters or more in this field.
You could try this instead, if you just want to check this condition:

SELECT * FROM mymodel WHERE LENGTH(some_text_field) = 100 ;

这篇关于Mysql在正则表达式上抛出异常的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！