(1135859,'user@hotmail.com','password','Male',21,'Anna',' IL','United States of America',0,2,0,'2008-02-17 13:11:47','0000-00-00 00:00:00'),
 (1135860,'user@yahoo.com','password','Male',32,'New York',' NY','United States of America',0,2,0,'2008-02-17 13:11:47','0000-00-00 00:00:00'),


open(MYINPUTFILE, "<db.sql");
open(MYOUTPUTFILE, ">users.txt");

while(<MYINPUTFILE>)
 {
 ($u,$p) = /^\s*\(\s*\d+\s*,\s*'\''((?:[^'\'']|'\'\'')*)'\''\s*,\s*'\''((?:[^'\'']|'\'\'')*)'\''/ or next;s/'\'\''/'\''/g for$u,$p;
 }

print MYOUTPUTFILE "$u:$p";

close(MYINPUTFILE);
close(MYOUTPUTFILE);