我的朋友经营一个FORUM,他问要如何:
1. extract only user-password column of the sql ?
Example:
('109', '200', '', '0', 'Fref', 'af6ebb48b7b4bd081ca95', '2007-09-21', 'xxxx@yahoo.com', '0', '', '', '', '', '', '', '', '1', '0', '0', '51', '1', '10', '5', '0', '0', '0', '0', '0', '0', '3159', '0', '', '0000-00-00', '-1', '-4', '', '0', '0', '0', '0', '-1', '0', '0', )
Fref 是USERNAME, af6ebb48b7b4bdf081ca95 是PASS. 要如何只是 extract username/password but not all data ? Excel 能做到吗?
谢谢 |