I need to extract the following for all orders in our magento 18.104.22.168 install:
The trouble is many of our guests do not bother entering a firstname or lastname, so the sales_flat_order table contains NULL values for the name part - can I pull this from anywhere else?
This is the query I have been using:
SELECT increment_id, customer_email, customer_firstname, customer_lastname
BETWEEN ‘100023275 ‘
Any help greatly appreciated.