Many to many lookup of matching words
I have a table which I'm treating as a lookup table.
It's format is something like.
1 This is item 1
2 This is another item
3 Item three
However I have 1000's of key values.
I want to retrieve the key when I pass in a string to compare.
e.g. my data is in another table might be
However my main data table has 10's of 1000's of rows.
And I want these to respectively match key
1 (matched lookup on "1")
2 (matched lookup on "another")
3 (matched lookup on "three")
What would be the recommended approach to this please.
I've successfully achieved this for another challenge where I want match a single word that matches a single value.