Export List + List Fields from Mysql Command Line

pconsulting

New Member
Hello

I am trying to use mysql to export a large list along with several fields pertaining to the list for confirmed subscribers. Can a sql ninja help me out with this query?

Thanks
 

pconsulting

New Member
Back to update on progress.. was able to do what I needed by sticking it all into temp table.. gotta do each field at once

mysql> update tmp1_details as t1 inner join mwiz.mw_list_field_value as fv on t1.subscriber_id=fv.subscriber_id set t1.first_name=value where fv.field_id=222;
 
Top