What program do i need to open a sql file?

EmEditor.

text editor ..

any editor will do the job, notepad++, atom, sublime text 
for editing phpmyadmin is great

Emeditor works best

Notepad. You open it in a notebook and delete all the SQL slag.

EmEditor is best. more faster than others

And if you want to extract only one column like emails?

Emeditor or any text editor which can handle big files.

i use Notepad++