I am using LIKE operator for search but it brings so many results, for example if I just enter ''a'' it brings up almost everything since its the most common letter. is there any way to match the whole word with LIKE? 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 -~----------~----~----~----~------~----~------~--~---
Vapor .. wrote:> I am using LIKE operator for search but it brings so many results, for > example if I just enter ''a'' it brings up almost everything since its the > most common letter. > > is there any way to match the whole word with LIKE? > > thanksinstead ogf LIKE you can use "="then you can match the whole word -- 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 -~----------~----~----~----~------~----~------~--~---
On Oct 25, 3:09 am, Abhi Manyu <rails-mailing-l...-ARtvInVfO7ksV2N9l4h3zg@public.gmane.org> wrote:> Vapor .. wrote: > > I am using LIKE operator for search but it brings so many results, for > > example if I just enter ''a'' it brings up almost everything since its the > > most common letter. > > > is there any way to match the whole word with LIKE? > > > thanks > > instead ogf LIKE you can use "="then you can match the whole word > -- > Posted viahttp://www.ruby-forum.com/.BTW there''s a number of search plugins for rails, including some built on MySQWL, postgres etc. full text search, e.g. acts_as_fulltextable, acts_as_tsearch, http://agilewebdevelopment.com/plugins/search?search=search --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---