Complete word search?

Rails
1

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

2

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

3

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