How to extract emails from database

[gregy]

Our customer agree that we can add their email to our mailing list .. which is not part of OSC .. so we add them manually to other database ...

 

So, how can i (command) extract emails from customer ID 12 up to ID 312? .. only emails

 

thanx

[Rob123]

Try this..

select  customers_email_address from customers where customers_newsletter = '1' and customers_id >= '12' and customers_id <= '312';

 

It is untested but it should work (I may have a typo).

HTH,

Robert