Trying to count how many times words from one table match a column in another table
I am not even sure if a query like this is possible without some scripting around it.
I have a table of keywords (ie: bunny, hamster, chicken, clock, wall, etc.) and I want to count how many times those keywords are found in the title column of another table in my database.
The other table has a column called 'title' and it is filled with rows of information like:
The black bunny and yellow chicken turned back the clock.
We have five clocks on our wall.
Our house has two hamsters and one chicken stuck in the wall.
Every bunny has its picture on someones clock.
I want the query to count up how many times the keywords appear in all of the rows of titles.