Archives
Trending
Support
Login
clear text
XML
Django
JavaScript
MATLAB
C
C++
C#
Python
SQL
Shell
Bash
Markdown
YAML
JSON
HTML
CSS
PHP
Java
Ruby
Go
Rust
Swift
Kotlin
Arduino
TypeScript
Perl
Autohotkey
Lua
SQF
R
Scala
Haskell
Groovy
Dart
Clojure
VB.NET
Objective-C
PowerShell
Bash
CoffeeScript
Verilog
#Android SMS text messages are stored in sqlite db: db="/data/data/com.android.providers.telephony/databases/mmssms.db" #list messages info: sqlite3 $db "SELECT * FROM sms" sqlite3 $db "SELECT date,address,body,type FROM sms" #filter by phone number sqlite3 $db "SELECT date,address,body,type FROM sms WHERE address LIKE '%5555555%'" #Search through MMS Attachments sqlite3 $db "select * from part" #Get Text from MMS messages sqlite3 $db "SELECT text FROM part WHERE name LIKE '%text%';" #Get list of Image file attachments SELECT _data FROM part WHERE cl LIKE "%image%"; #Android MMS Attachments are stored in: /data/user_de/0/com.android.providers.telephony/app_parts/ #Get Last 50 Messages by date SELECT * FROM (SELECT * FROM sms ORDER BY date DESC LIMIT 50) ORDER BY date ASC; #last 50 as JSON sqlite3 -json $db "SELECT * FROM (SELECT * FROM sms ORDER BY date DESC LIMIT 50) ORDER BY date ASC;" |jq .
Mark as private (unlisted)
for 30 minutes
for 6 hours
for 1 day
for 1 week
for 1 month
for 1 year
everlasting (like CCCP)
