For Loop

[Mario di Filippo]

Hello,

I a beginner to MySQL and I would like some guidance on the following task.
I need to run the command below on different databases for different values:

SELECT * FROM DB1 where FIELD1 ='AA'

For example if the databases are {DB1;DB2} and the values of FIELD1 are {AA; BB}
I need a loop that does:

SELECT * FROM DB1 where FIELD1 ='AA'
SELECT * FROM DB2 where FIELD1 ='AA'
save results in AA.xls

SELECT * FROM DB1 where FIELD1 ='BB'
SELECT * FROM DB2 where FIELD1 ='BB'

save results in BB.xls


Thank you very much for any help,

Mario