New on LowEndTalk? Please Register and read our Community Rules.
All new Registrations are manually reviewed and approved, so a short delay after registration may occur before your account becomes active.
All new Registrations are manually reviewed and approved, so a short delay after registration may occur before your account becomes active.
Comments
More informations? Are you using a CMS for your site?
select email_col from table_name
Please add more information. Like what is the cms behind your website. What is your database type.
@sdglhm @MuZo
Sorry for my explain..
Here is CMS im using - http://goo.gl/4LWHC2
here is Screenshot
http://postimg.org/image/oj8trams9/
http://postimg.org/image/4ncubr5qx/
i want to download all email address.. how i do that?
Open your users table. Then select the export based on that column
Dear i want User email List only... not users backup
That's why I've told you export based on that column. You can use CSV export.
Check this image - http://postimg.org/image/4k6hn0e4x/
so how ?
You'll have to use select with into outfile sql query. Or you can achieve this easily by using MySQL work bench.
im a new for this field so I don't know exactly how i make it... i have install MySQL workbench but its not working.. anyway.. can you please tell me step by step? than hug help for me
Enable remote SQL on your web hosting and connect your Work bench with your data base. Use % as the IP because most of the times Sri Lankan IP's are fairly random.
Then run a select query with your table. Export the result as CSV
Select email from users; would be the SQL query to get only users email address. You can use the query tool on phpmyadmin and copy the text result. There are other ways, it depends how you want to work with your data.