SQL LIKE with an IN

[dAmoTa]

Please help me 🙂

I have two tables each with only one relevant column

Table1.Paragraph
50,000 paragraphs of text

Table2.Firstname
4,000 names

I want to retrieve any paragraphs which contains a name from the firstnames list although the names could be anywhere inside the paragraph.
I only have MS Access 2010.

Something like this?

SELECT Table1.Paragraph From Table1 where Paragraph IN(Select %Firstname% from Table2)???

Any suggestions would be greatly appreciated! 🙂 Cheers in advance

[kristian_kolb]

Do you have these indexed in Splunk already?

Perhaps this page may give some guidance;

http://docs.splunk.com/Documentation/Splunk/latest/SearchReference/SQLtoSplunk

/K

[kristian_kolb]

This the user forum for the Splunk product. Most likely, Splunk can do what you want it to do with your data.

www.splunk.com

Good Luck, K

[dAmoTa]

maybe I've misunderstood here - I dont know what splunk is - i thought it was a forum

[dAmoTa]

Thanks Kristian for replying 🙂 However I don't really understand what you mean

[martin_mueller]

Use Splunk instead of MS Access 🙂