List,

I have a file named 'hits' om my drive that looks like:

43 10.10.10.1
79 10.11.12.12
678 10.23.34.45
...

At the moment I create a MySQL batch file from the 'hits' file like above and run the batch query:
SELECT * FROM sitelist WHERE address LIKE 10.10.10.1
SELECT * FROM sitelist WHERE address LIKE 10.11.12.12
SELECT * FROM sitelist WHERE address LIKE 10.23.34.45
...

The result then looks like:
Rome
Amsterdam
Brussels

while I'd better like something like this:
43 10.10.10.1 Rome
79 10.11.12.12 Amsterdam
678 10.23.34.45 Brussels
...

I have no clue how to combine the 'hits' with the result of the query... Anyone an idea?

Kind regards,

Philip

SELECT '10.10.10.1,* FROM sitelist WHERE address LIKE 10.10.10.1

I think I miss something here...
Would that code go into the batch file?

Would that give me the following output:
43 10.10.10.1 Rome
for every entry?

Ah.. I missed the '43' part and misunderstood the rest.

Efectively you want to join two files (where the first one is called 'hits' and second one generated by those select lines)?
You can use 'paste' to do this.

Something like 'theScriptThatDoesTheSelectThing | paste hits -'
See 'man paste' or 'info paste' for details.