I have an entity named Book with 3 fields: Title, Description and Notes.
And I have two words: "Camões" and "Manuscript".
I would like to get all records that contains one or both words in any of the fields described above.
How can I do this?
And can I do the following?
1 - Word "Camões" would be the same as "Camoes";
2 - Order the results by the number of occurrences.
First books where the two words were found.
Second books were only one word was found.
Is this possible?
View Complete Post