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/
On 03/04/2008, at 12:49 AM, Guido Holz wrote:
>
> 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 !
> --
> Posted via http://www.ruby-forum.com/.
>
> >
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---