rails find records containing specific word

Question

I'm looking for a way to find all entries in a database containing a specific string. I know it's possible to iterate over every entry and see if a string matches but with a growing database i'd rather not do that. I'm wondering if there is a Rails way of doing it. something like

Table.where("content containsWord ?", "string")

So a function find all records containing a specific string. Does anyone know a way to do this?

update

duplicate of Rails: How to find_by a field containing a certain string

@mischa When I written the same thing what RSB has written in my comment then you said it's not working...why so? — Vrushali Pawar, Jun 08 '15 at 10:02

Rajdeep Singh · Accepted Answer · 2015-06-08T10:23:39.203

9

You can try this

search_term = "string"
tables = Table.where("tables.content LIKE ?", "%#{search_term}%")

or, if you want to ignore case sensitiveness, then do this

search_term = "string"
tables = Table.where("lower(content) LIKE lower(?)", "%#{search_term}%")

Hope this helps!

edited Jun 08 '15 at 10:23

answered Jun 08 '15 at 10:00

Rajdeep Singh

17,621
6
53
78

1

This is what i mean, the only problem i'm still having is that it needs the correct capitalization. I would prefer it if i'm looking for "content" that it also picks records with "Content" – Mischa Jun 08 '15 at 10:15
1

Check my edited answer, it will work for your case – Rajdeep Singh Jun 08 '15 at 10:23
@mischa What is the DB engine you are using > – Arup Rakshit Jun 08 '15 at 10:25

rails find records containing specific word

1 Answers1