I'd like to search for special word on almost all field of a table. It could be a word from a sentence or a full sentence.
Right now, I do it on one field and the word must match case. I'd like to use a 'like' but I don"t see how.
select * from UserTable where General in (select Word from AlertWorldTable where UserID = " + currentUserID + ") ";
UserTable definition :
thanks for your lights