Search and replace
Posted
by zx
on Stack Overflow
See other posts from Stack Overflow
or by zx
Published on 2010-05-10T12:47:18Z
Indexed on
2010/05/10
12:54 UTC
Read the original article
Hit count: 300
Hi,
I have a really large SQL dump around 400MB.
It's in the following format, "INSERT INTO user VALUES('USERID', 'USERNAME', 'PASSWORD', '0', '0', 'EMAIL', 'GENDER', 'BIRTHDAY', '182', '13', '640', 'Married', 'Straight', '', 'Yes', 'Yes', '1146411153', '1216452123', '1149440844', '0', picture', '1', '0', '0', 'zip', '0', '', '0', '', '', '0')"
Is there anyway I can just get the email and password out from that, I want to import the users into another table.
Anyone know how I can do this and just get email-password stripped out from that content?
Thank you in advance
© Stack Overflow or respective owner