SQLITE and I'm trying to find the exact word on a sentence, but I'm not getting just the word I'm getting for instance if I'm looking for
Water I'm getting also
wateri24 and that's not what I'm looking for.
I've created an example here on
sqliteonline to show you how do I store the sentences, there are in table b.
This is an example of what is happening
NOTE: I'm looking for an answer that uses ignore cases, for instance if I want to find
water I want to get
WatER, and so...
What I'm missing?