How to search in database by like query in ruby on rails?

Question

i am using rails and mongo db as database simply i want to search I have a field name role Now i send the search item in

params[:role]
params[:name]

Now i have the model User now what could be my query to search the data in the User model like params[:name] I did like

 @role = params[:role]
    @name = params[:name] 
     @data = User.{where(:role => @role)}.where("description LIKE (?)",
    "%#   {@name}%").desc(:created_at).
    excludes(:id    => current_user.id)

Above query is just analysis. I mean to say it should like in therotical but i didnt get id.

Did you even tried to search this? stackoverflow.com/questions/10326662/search-through-sentences — Vadym Chumel
– Vadym Chumel, Commented Oct 9, 2012 at 14:10

Hugo Logmans · Accepted Answer · 2012-10-09 14:01:18Z

1

Does this work? (from my head...)

 @role = params[:role]
 @name = params[:name] 
 @users = User.where(:role => @role)
 @data = @users.where(users[:description].matches("%#{@name}%")).order("created_at desc").excludes(:id=> current_user.id)

answered Oct 9, 2012 at 14:01

Hugo Logmans

2,2521 gold badge19 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

regmiprem Over a year ago

what is users here? I dont understand. and (:description) is the field name of users collection?

Hugo Logmans Over a year ago

users[:description].matches("%#{@name}%") is the AREL-version of "description LIKE (?)". I took those names from your commands, you you should know what they actually stand for :)

regmiprem Over a year ago

If i want to match with other field also like field :email :address with @ name then what should i do?

Collectives™ on Stack Overflow

How to search in database by like query in ruby on rails?

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related