LOAD DATA INFILE Question

[mpar612]

Hello,

I am using the following SQL statement: LOAD DATA INFILE 'idxrs051309.txt' INTO TABLE residential FIELDS TERMINATED BY '|' LINES TERMINATED BY '\n';

It works great, but I want to use this for a job and date in the name of the file changes everyday. Can I replace the 'idxrs051309.txt' with something equivalent to idxrs*.txt?

Thanks in advance!

[dagon]

if your calling it with a php script you could use php to set the file name