Android Contacts – Show Contact Names

Posted on By David Kittell 
SELECT
data1 AS FullName, data4 AS Prefix, data2 AS FirstName,data5 AS MiddleName, data3 AS Lastname, data6 AS Suffix
FROM data
INNER JOIN mimetypes ON mimetype_id = mimetypes._id

WHERE mimetype LIKE "%name%"
	AND length(data1) > 0

and data2 <> ""
and data3 <> ""
ORDER BY Lastname
Originally Posted on March 2, 2014
Last Updated on October 26, 2015
All information on this site is shared with the intention to help. Before any source code or program is ran on a production (non-development) system it is suggested you test it and fully understand what it is doing not just what it appears it is doing. I accept no responsibility for any damage you may do with this code.
Android SQLite Code SQL SQLite

Related Posts

Ubuntu – Create Samba Share

Posted on

sudo apt install samba cd /etc/samba sudo cp smb.conf smb.conf.bak sudo mkdir -p /var/shares/public sudo chmod 755 -R /var/shares/ echo "[Share]" | sudo tee -a smb.conf echo "comment = Samba file share." | sudo tee -a smb.conf echo "path = /var/shares/public/" | sudo tee -a smb.conf echo "browseable = yes"…

Read More

Show Windows Version On Desktop

Posted on

WARNING: Backup the computer you try these scripts on before you run these. Windows Registry Editor Version 5.00 [[HKEY_CURRENT_USERControl PanelDesktop] "PaintDesktopVersion"=dword:00000000 Originally Posted on November 9, 2013Last Updated on October 26, 2015 All information on this site is shared with the intention to help. Before any source code or program…

Read More

List Tables In Database

Posted on

SELECT t.name ,i.rows FROM sys.tables AS t INNER JOIN sys.sysindexes AS i ON t.object_id = i.id AND i.indid < 2 ORDER BY t.name Originally Posted on February 25, 2013Last Updated on October 26, 2015 All information on this site is shared with the intention to help. Before any source code…

Read More