awk searching strings from file

Question

I'm currently using

 $ awk 'NR==FNR{a[$1];next} ($3 in a)' find.txt path_to_100_files/*

which uses find.txt strings to search multiple files within path_to_100_files/ for matches.

find.txt contains

[email protected]
[email protected]

and then path_to_100_files/ contains files such as

0.0.0.0:002921931:[email protected]
123.0.0.1:00029382:[email protected]

now what this is doing is only searching the 3rd column for the strings from find.txt, but i need it to search the entire file/every column?

as some files may be 5 columns long, or 9 columns long example,

0.0.0.0:002921931:1111111:[email protected]
123.0.0.1:00029382:1111111:11111:[email protected]

I've tried to change ($3 in a) to like ($0-$9 in a) but doesn't seem to work?

Solution

Why search fields one-by-one? Why not search whole lines at a time?

grep -f find.txt path_to_100_files/*

Comments

[Wildcard]

You should add a -F as well for fixed-string search.

[done]

@Wildcard As well as add a -o to only output matches.