urgend question for using REGEXP in find-query

rubyonrails-talk
1

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 !

2

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/