I have a table called ‘entries’ with lots of sentences, one per row
(id). I need to find specific sentences that have the words I’m looking
for anywhere in them. For example:
The bird entered the kitchen through the door.
You left the door of your car open.
Close the window or the bird will get out of the car.
If I search for ‘bird’ and ‘door’, I want only the sentence with the id
1 to come up. If I search for ‘door’ and ‘car’, I want only the sentence
with the id 2 to come up. If I search for ‘bird’ and ‘car’, I want only
the sentence with the id 3 to come up.
So, basically, what this grep command would do:
cat my.file | grep bird | grep door
But I’m not getting anywhere with any search technique or plugin I’ve
tried so far. Any ideas?
I have a table called ‘entries’ with lots of sentences, one per row
(id). I need to find specific sentences that have the words I’m looking
for anywhere in them.
If you’re using MySQL, you can create a FULLTEXT index on the
field(s) in question and use MATCH: