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
See Question&Answers more detail:os