Android Contacts – Remove Email Addresses

Posted on By David Kittell 
DELETE FROM data
WHERE mimetype_id IN (
        SELECT _id
        FROM mimetypes
        WHERE mimetype LIKE "%email%"
        )
    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

Ektron – Find DMS Content File

Posted on

Sometimes you’re asked where a DMS file exists on the server and have to track it down, this query should help. Caveat: It helps to know where your root/main asset directory is on your server. SELECT content_id AS "Content: Content ID" ,content_title AS "Content: Content Title" ,(storage + ‘.’ +…

Read More

Ektron Alias List

Posted on

SET NOCOUNT ON DECLARE @Domain VARCHAR(50) SET @Domain = ‘<domain>’ SELECT AliasName ,(@Domain + alias_pagename) AS AliasURL ,(@Domain + alias_logical) AS ActualURL ,content_id ,content_language FROM url_alias_tbl LEFT OUTER JOIN UrlAliasManual_Tbl ON UrlAliasManual_Tbl.aliasid = url_alias_tbl.alias_id ORDER BY AliasName SET NOCOUNT ON DECLARE @Domain VARCHAR(50) SET @Domain = ‘<domain>’ SELECT (@Domain +…

Read More