search for: tp22860193p22865610

Hello, I'm accessing a MySQL database from inside R and had a problem with a function. In the database, there is data from years 1985 to 2007 that I would like to retrieve. I can easily get the data from one year by the following: info1985=dbGetQuery(con, statement='the SQL query') Inside the statement, I have a column that is set to the desired year (e.g. table.column=1985) through