Export database records by Year

[jake66]

I have database in which I would like to export all records that were posted in the year 2006 in plain text or gzip (holding true to the SQL structure of

INSERT INTO `table` VALUE...

and such)

The dates are stamped as follows: 2006-09-25 21:49:28

I've searched the web for a pre-written script but haven't located one yet. Any suggestions how I can achieve this?

[Discovery]

I am not sure,
But what you can do, Copy Table with Condition [java2s.com],

eg,
CREATE TABLE MyEmployee SELECT * FROM Employee
where Age > 30;

and export a table.

or

You can also export with condition read example in User Comments of the link [dev.mysql.com]

[jake66]

Thank you, I believe I got the SQL portion of it down now.

I just can't seem to get the date specs correct.
Can anybody spot what I'm doing incorrectly here?

select * from table_tobepurged where `date_stored` < DATE(2007-01-01 01:01:01) order by orders_id asc limit 5

[jake66]

Got it to work:

select * from table_tobepurged where date_stored BETWEEN '2006-01-01' and '2007-01-01' order by orders_id asc limit 5