To get all jobs which invoice_number is a pure number I do:

Job.where("invoice_number REGEXP '^[[:digit:]]+$'")

Is it possible to do the same by specifying the regex in Ruby rather than MySQL ?

mysql ruby-on-rails regex ruby-on-rails-3 activerecord
Edit
Report