topic SQL LIKE with an IN in Splunk Search

SQL LIKE with an IN

dAmoTa — Wed, 27 Mar 2013 08:16:41 GMT

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

Re: SQL LIKE with an IN

martin_mueller — Wed, 27 Mar 2013 08:20:19 GMT

Use Splunk instead of MS Access 🙂

Re: SQL LIKE with an IN

kristian_kolb — Wed, 27 Mar 2013 08:28:53 GMT

Do you have these indexed in Splunk already?

Perhaps this page may give some guidance;

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

Re: SQL LIKE with an IN

dAmoTa — Wed, 27 Mar 2013 09:01:36 GMT

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

Re: SQL LIKE with an IN

dAmoTa — Wed, 27 Mar 2013 09:03:06 GMT

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

Re: SQL LIKE with an IN

kristian_kolb — Wed, 27 Mar 2013 09:10:47 GMT

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