Dear John,
probably the problem does not derive from MySQL, but from the URL encoded
search string, e.g.:
Search for "oneword" => oneword
Search for "two words" => two%20words
If you match against "two words", there will be no match, as it should match
against "two%20words".
I am not informed
Hi,
If I have two MYSQL tables with two columns for email addresses respectively:
csc_teammembers.tes_email AND cscflash_mb.email
Now, what I want to do is query only those email addresses in cscflash_mb that
DO NOT have a match in the csc-teammembers dbtable.
Can I just do a select statement
I am assuming from your email that the field ID allows duplicates. In that
case, use the SELECT DISTINCT syntax ... that will get you back the 1 row
you are looking for. However, if the (ID,CompetitorName) tuple is unique,
SELECT DISTINCT will NOT help.
Hope this helps
Raj
At 06:12 PM 9/23/200
