Ruby on Rails

On 28 October 2015 at 07:00, honey ruby <emailtohoneyruby@gmail.com> wrote:
> Hi all,
>
> In a table there is column called village which is text datatype. Now my
> question is few records will have 1,2 under village column some records will
> have only 2 or 1. when I do query I should be able to select those records
> which has 1,2 . If I want to select all the records of village(2). How can I
> do this in rails query.
>
> Tried with Like and IN (?) in query but did not work
>
> City.find(:all, :conditions => ["village LIKE ?",2])
> City.find(:all, :conditions => ["village IN (?)",2])
>  as it is text datatype and if I pass 1,2 I am able to get the records but
> while passing single value like 1 or 2
>
> Kindly suggest how to get it

Don't store the data like that, it will cause you endless problems and
you will look back in the future and ask why you did it that way.
Possibly it should be in separate fields, or even in a separate table.
It depends what the data represents.  If you provide the context then
it may be possible to suggest the best alternative.

Colin

--
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email to rubyonrails-talk+unsubscribe@googlegroups.com.
To post to this group, send email to rubyonrails-talk@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/rubyonrails-talk/CAL%3D0gLvzeWMA7nVB1WW9ZAE%2BW15JTuFpEjdko125DpL0h4BVGA%40mail.gmail.com.

For more options, visit https://groups.google.com/d/optout.