The group you are posting to is a Usenet group. Messages posted to this group will make your email address visible to anyone on the Internet.
Your reply message has not been sent.
Your post was successful
 |
From: jonknee <m...@jongales.com>
Date: Thu, 27 Mar 2008 17:15:50 -0700 (PDT)
Local: Thurs, Mar 27 2008 8:15 pm
Subject: Re: Run query in background while showing "Please wait"
> I may have not explained the setup properly. I don't actually have a
That should still be able to be handled pretty easily with SQL. You
> "full_name" field in either table (import_contacts and contacts are > the actual MySQL table names). Each of these tables have "fn" and "ln" > fields, however. So the problem is that I need to somehow find all > records in the contacts table which have the same values in the "fn" > and "ln" fields as the import_contacts table. got me interested so I created a test DB formatted like you said (first_name, last_name) and this query works fine. Only spits out the dupes (when first and last names are the same, if one of the two is different it doesn't show up): SELECT * FROM contactImport WHERE first_name IN (SELECT first_name
b logica's way would work too, so you could just check whatever is
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
| |||||||||||||