Search model in Ruby on Rails with multiple words query string

Question

I have a Ruby on Rails app, and I am trying to perform a search through a model. From the front end, I am passing the query string.

In courses_controller.rb I have the following code:

 ...
 Course.where("courses.name ILIKE ?", "%#{params[:search]}%")
 ...

If params[:search] is equal to something like "marketing", it will retrieve the item with name "marketing course". But if params[:search] is equal to "marketing course", nothing is retrieved.

How can I perform search with multiple words?

Thanks a lot.

Does this answer your question? postgres full text search like operator — dbugger
– dbugger, Commented Apr 11, 2022 at 14:08

David Wolf · Accepted Answer · 2022-04-12 04:59:42Z

1

Probably you need to check the value of params[:search].

Spaces in query string can be encoded with + or %20 chars.

So, in this case, you're trying to find something like marketing+course or marketing%20course which doesn't exist in the database.

edited Apr 12, 2022 at 4:59

David Wolf

1,7382 gold badges14 silver badges21 bronze badges

answered Apr 11, 2022 at 14:53

Vadim Dokurno

334 bronze badges

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

Comments

Matteo · Accepted Answer · 2022-04-11 14:57:44Z

0

Turns out I found a way:

 ...
 Course.where("courses.name ILIKE ?", "%#{params[:search].tr('-', ' ')}%")
 ...

It was adding unwanted "-" between words.

answered Apr 11, 2022 at 14:57

Matteo

632 silver badges7 bronze badges

Collectives™ on Stack Overflow

Search model in Ruby on Rails with multiple words query string

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related