Complete word search?

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

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

On Oct 25, 3:09 am, Abhi M. [email protected]
wrote:


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

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