Urgend question for using REGEXP in find-query

Hi…

my table is Number… in this table I have column named “list”

each entry of a column has a list of numbers like:

“3452 45869 234 12”

know I have to know, how I can query the database via Number.find(:all,
:condition => {…!!!..}) to find a specific number… a number can
exists in different datasets… so I need all entries, where the number
is in “list”.

normaly in SQL I use (searching for the number 234)

SELECT * FROM Number WHERE list REGEXP ‘\s*\s*’

How can I use find with it?!?

thanks !

Hi,

ARCLASS.find(:all, :conditions => ‘put the where statement in here’)

you can put “list REGEXP ‘\s*\s’” as the conditions, and it should be
fine.

Julian.

Learn Ruby on Rails! CHECK OUT THE FREE VIDS (LIMITED TIME) NEW VIDEO
(#2) OUT NOW!
http://sensei.zenunit.com/

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs