[RESOLVED] Finding Count of Word in One Column in Another Column

[perpetualshaun]

As I'm migrating our data from one DB schema to another, I found some oddities in the data. Here's a screenshot of my table structure:

[ATTACH]5291[/ATTACH]

So I'm wondering how I can write a query (I assume it's possible) that will tell me how many times a word in the SynonymWord column appears in the SynonymMatch column? Anyone out there know how I could write such a query?

Data Issues in the CommentsRelatedWords Table.png

[jeepin81]

Look into sql subquery's. non-test example:

SELECT tab1.SynonymWord, tab1.SynonymMatch FROM table AS tab1 WHERE (SELECT count(*) FROM table AS tab2 WHERE tab1.SynonymWord = tab2.SynonymMatch)