Need to get all orders in a date range by sql

[navido]

Hi

From phpadmin i try to get all orders (only some columns) from the table orders.

I need to get a list for march 2013

This is what i have tried (this is just an example i tried for 2011):

SELECT 'orders_id',`customers_name`,`order_total`,`payment_method` FROM 'orders' WHERE 'date_purchased' BETWEEN '2011-02-01' and '2011-02-01';

But i get en error.

Can anyone show me the code i have to use?

Thanks