Android SMS and MMS Text Message info

#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 .