Android Contacts – Remove Websites

Posted on By David Kittell 
DELETE FROM data
WHERE mimetype_id IN (
        SELECT _id
        FROM mimetypes
        WHERE mimetype LIKE "%web%"
        )
    AND
        data1 LIKE '%facebook.com%';
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

Connect to SSH from Terminal

Posted on

When on a UNIX based computer you can connect to another terminal via SSH using this command ssh -p 22 user@your.ip.address The -p defines the port, while 22 is the default port for SSH some servers change their port to ward off potential hackers. Make sure you know what the…

Read More

Azure PowerShell – Create Virtual Network Within Resource Group

Posted on

This is still a work in progress to include all the variables but the script below will create a Resource Group then create a Virtual Network with 3 subnets and a gateway along with custom DNS. # Main Reference: https://docs.microsoft.com/en-us/azure/virtual-network/virtual-networks-create-vnet-arm-ps Clear Write-verbose "Setting Environment Variables – Start" $VNetName = “azuredev-eastus-vnet”…

Read More

PowerShell – Create System Path

Posted on

Possibly the easiest manual way is in Windows 10 and Windows 2012 R2 (likely previous versions too but don’t have them handy while writing this): From the Desktop, right click on the Windows icon (Start Menu) in the bottom left of the screen Click on “System” Click the “Advanced system…

Read More