Search for dictionary words in another table
Posted on 2010-11-26
I have one table with dictionary words (4000 words) like this:
And I have a table with content (articles).
I need to find what Titles from tableDictdionary is actually found in tableContent.Title,Shorttext and fulltext and if found update tableDictionary.Hits with number of occurences. 0,1,2,3,4 ...
Both tables are indexed fulltext if this help?
I just need to run this query once to update the tableDictionary.Hits column.
Pls ask me if you need more info.
I need full code that is working.