Passing variable to SQL script

[Robert Hammer]

Hi,

I'd like to pass in a parameter to a sql query at execution time using mysql command line. Something like this:

>mysql -uuser-ppw < run.sql &1='2007-06-28'

Where &1 is part of a where clause in run.sql.

I don't want to use the -e option since the actual SQL is quite long.

I know this can be done in Oracle .. how would I do this with MySql?

Thanks in advance.