Thunderbird forensic
De Linuxmemo.
(Différences entre les versions)
(→global-messages.db.sqlite) |
|||
| Ligne 3 : | Ligne 3 : | ||
SELECT contacts.name, identities.value FROM contacts, identities WHERE contacts.id=identities.id; | SELECT contacts.name, identities.value FROM contacts, identities WHERE contacts.id=identities.id; | ||
| - | SELECT contacts.name, identities.value FROM contacts, identities WHERE contacts.id=identities.id AND | + | SELECT contacts.name, identities.value FROM contacts, identities WHERE contacts.id=identities.id AND contacts.name LIKE '%bank%'; |
SELECT contacts.name, identities.value FROM contacts, identities WHERE contacts.id=identities.id AND contacts.name LIKE 'BEA'; | SELECT contacts.name, identities.value FROM contacts, identities WHERE contacts.id=identities.id AND contacts.name LIKE 'BEA'; | ||
Version du 7 janvier 2021 à 12:42
global-messages.db.sqlite
SELECT contacts.name, identities.value FROM contacts, identities WHERE contacts.id=identities.id;
SELECT contacts.name, identities.value FROM contacts, identities WHERE contacts.id=identities.id AND contacts.name LIKE '%bank%';
SELECT contacts.name, identities.value FROM contacts, identities WHERE contacts.id=identities.id AND contacts.name LIKE 'BEA';
