Mysql throwing exception on Regex

Question

This works:

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

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

but not this:

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

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

m4573r · Accepted Answer · 2012-09-07 14:01:23Z

1

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 ;

edited Sep 7, 2012 at 14:01

answered Sep 7, 2012 at 13:53

m4573r

9907 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

ashish Over a year ago

Thanks, this worked for me. But i am just curious about the above queries. #1 gives 1, #2 gives 0 as results but #3 throws exception. If there are no matching rows, then answer should be 0, it shouldn't throw an exception.

m4573r Over a year ago

I agree with that, it's kinda nasty :)

Collectives™ on Stack Overflow

Mysql throwing exception on Regex

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related