Skip to content
David Kittell
David Kittell

Application & System: Development / Integration / Orchestration

  • Services
    • Application Development
    • Online Application Integration
  • Code
  • Online Tools
  • Tech Support
David Kittell

Application & System: Development / Integration / Orchestration

Android Contacts – Clear Name If It Matches Company Name

Posted on February 21, 2014October 26, 2015 By David Kittell
UPDATE data
SET data1 = NULL
	,data2 = NULL
	,data3 = NULL
WHERE mimetype_id IN (
		SELECT _id
		FROM mimetypes
		WHERE mimetype LIKE "%name%"
		)
	AND raw_contact_id IN (
		SELECT raw_contact_id
		FROM data dt1
		INNER JOIN mimetypes ON mimetype_id = mimetypes._id
		WHERE mimetype LIKE "%name%"
			AND length(data1) > 0
			AND data1 LIKE (
				SELECT data1
				FROM data dt2
				INNER JOIN mimetypes ON mimetype_id = mimetypes._id
				WHERE mimetype LIKE "%organization%"
					AND length(data1) > 0
					AND dt1.raw_contact_id = dt2.raw_contact_id
				)
		);
Originally Posted on February 21, 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.

Related

Android SQLite Code SQL SQLite

Post navigation

Previous post
Next post

Related Posts

Bash – Unix – Identify Distribution (What OS Am I On)

Posted on June 4, 2020August 17, 2024

Unix Identification is a script that originated with VMWare but I have added some other systems to the script. No Install Option /bin/bash -c "$(curl -fsSL https://gitlab.com/Kittell-Projects/Unix/unixidentification/raw/master/UnixIdentification.sh)" $ /bin/bash -c "$(curl -fsSL https://gitlab.com/Kittell-Projects/Unix/unixidentification/raw/master/UnixIdentification.sh)" What details would you like to see? -a is for all details. -d is for full OS…

Read More

C# ASPX – Force SSL

Posted on July 9, 2013June 13, 2017

Why would I need this? If you have a page that loads in HTTP (unsecure) and HTTPS (secure) you may have a need for this when requesting information on a form that involves private information. What is “Private” information Up to your discretion but a site (http://support.exware.com/ssl.html) that I found…

Read More

Azure RM – Remove Azure RM PowerShell Modules

Posted on March 7, 2018

foreach ($module in (Get-Module -ListAvailable AzureRM*).Name |Get-Unique) { write-host "Removing Module $module" Uninstall-module $module } 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…

Read More

Code

Top Posts & Pages

  • PowerShell - Rename Pictures to Image Taken
  • Front Page
  • C# - Start/Stop/Restart Services
  • MacPorts / HomeBrew - Rip CD tracks from terminal
  • PowerShell - Show File Extensions

Recent Posts

  • Javascript – Digital Clock with Style
  • BASH – Web Ping Log
  • BASH – Picture / Video File Name Manipulation
  • Mac OSX Terminal – Create SSH Key
  • Bash – Rename Picture

Top Posts

  • PowerShell - Rename Pictures to Image Taken
  • C# - Start/Stop/Restart Services
  • MacPorts / HomeBrew - Rip CD tracks from terminal
  • PowerShell - Show File Extensions
  • Open On Screen Keyboard (OSK)
  • SQLite - Auto-Increment / Auto Generate GUID
©2025 David Kittell | WordPress Theme by SuperbThemes