Can you do a where find with a regular expression in rails?

Question

I'm trying to find objects that begin with a number.

Syntactically this is off. But I would like to do something like this :

Object.where([name LIKE ?', /[1-9]/])

If that isn't possible, how do you suppose the best way to find all objects that start with a number?

score 2 · Answer 1 · answered Mar 08 '12 at 14:00

2

You can use rlike / regexp i would think. Though it's not portable across to other databases.

Object.where(['name rlike ?', '^[\d]'])

answered Mar 08 '12 at 14:00

Omar Qureshi

Hmm so that didn't work, but this did `where(['name rlike ?', '^[1-9]'])` – Trip Mar 08 '12 at 14:08

score 2 · Accepted Answer · edited May 23 '17 at 11:48

2

Object.where(['name REGEXP ?', '^[0-9]'])

edited May 23 '17 at 11:48

Community

answered Mar 08 '12 at 14:07

Lee Jarvis

2 Answers2