Run Query from MySQL Command Line fails

Hi,

I am trying to run a report directly from the MySQL commandline, as I need to output the data into our data integration system.

I have copied the select statement from the "show query" button, on a report I have made in the WebUI.

When I run the select statement, I get:

Error 1064 (42000): You have an error in you SQL syntax, check the manual that corresponds to your MySQL server version for the right syntax to use near '<from_lastquarter>) AND ((rc.EXECUTEDTIME !=0) AND (rc.EXECUTEDTIME IS NOT NULL' at line 1

I think the problem is the "<from_lastquarter>" section. Is this a variable that is normally replaced before the statement is run?

Does anyone have any suggestions as to how I can make this work?

Regards,
Mike