(record1) "<font color=red> This is font</font>"
(record2) "<font color=blue>This is a boy</font> this is a girl <font color=red>This is a baby</font>"
I have two records like the above.
WHERE message like '%font%'
The above code will retrieve Both (record1) and (record2).
I like to retrieve only (record1) with the key word "font" because (record1) has the key word "font" in the text while (record2) has no the key word "font" in the text although it has it in the HTML tags.
The below code is one of my trial for retrieving (record1) only.
But it doesn't retrieve not only (record2), but it doesn't retrieve (record1) either.
WHERE message like '%font%' and message not like '%<%font%>%'
Thanks in Advance