i have a field that has a sentence
i want to query the database to find all records with exactly that
word within any sentence in that column
for example 1 wanna find the word "its"
the sentence:
"today its gonna rain"
my sql:
select * from table x where column y like '%its%'
this wont work
what am i doing wrong?
thanks in advance