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

Question

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

Whilst Drupal does use braces to delimit table names, I wouldn't expect it to do this inside strings. — Lightness Races in Orbit
– Lightness Races in Orbit, Commented Apr 23, 2011 at 16:26

Lightness Races in Orbit · Accepted Answer · 2011-04-23 16:30:07Z

4

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.)

answered Apr 23, 2011 at 16:30

Lightness Races in Orbit

387k77 gold badges670 silver badges1.1k bronze badges

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

Collectives™ on Stack Overflow

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

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related