Using curly brackets({}) for REGEX in drupal db_query

I have a where clause in my query like开发者_如何学运维 this "WHERE sth REGEXP '[0-9]{5,10}'"

when I run this query in phpmyadmin it returns all matched records but in drupal it has no result.I think it's because drupal assumes everything like "{sth}" as a table.

how can I solve this problem?

Thanks

Your theory is correct.

Curly brackets used as repetition quantifier in regexes are removed as any other curly bracket. Pass the regex as an argument to db_query() instead like this:

db_query('SELECT name from {users} WHERE std RLIKE "%s"', '[0-9]{5,10}');

(I've had to guess at the rest of your query.)