Advertisement
Guest User

Untitled

a guest
Mar 1st, 2019
994
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.36 KB | None | 0 0
  1. SELECT WebUsername,
  2. WebPassword,
  3. Active,
  4. Email,
  5. AddlEmail,
  6. ShowYear
  7. FROM Exhibitors e
  8. WHERE e.Active = '-1'
  9. AND e.ShowYear = 2013
  10. AND (e.Email, e.AddlEmail) NOT IN ('test@test.com', 'test2@test.com')"
  11.  
  12. $emails = "'email@email.com', 'email2@email.com'";
  13. // example table data for 2 fields in question
  14. Row | Email | AddlEmail
  15. 1 | email@email.com | email3@email.com
  16. 2 | email4@email.com | email2@email.com
  17. 3 | email5@email.com | null
  18. 4 | email6@email.com | email7@email.com
  19.  
  20. CREATE TABLE `doubleSelect` (
  21. `Email` varchar(255) DEFAULT NULL,
  22. `AddlEmail` varchar(255) DEFAULT NULL
  23. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  24.  
  25. INSERT INTO `doubleSelect` (`Email`, `AddlEmail`) VALUES
  26. ('email@email.com', 'email2@email.com'),
  27. ('email2@email.com', 'email3@email.com'),
  28. ('email4@email.com', 'email5@email.com'),
  29. ('email6@email.com', 'email@email.com'),
  30. (NULL, 'email@email.com'),
  31. ('email2@email.com', NULL);
  32.  
  33. SELECT *
  34. FROM `doubleSelect`
  35. WHERE Email NOT
  36. IN (
  37. 'email@email.com'
  38. )
  39. AND AddlEmail NOT
  40. IN (
  41. 'email@email.com'
  42. )
  43.  
  44. AND e.Email NOT IN ('test@test.com', 'test2@test.com')
  45. AND e.AddlEmail NOT IN ('test@test.com', 'test2@test.com')
  46.  
  47. SELECT *
  48. FROM `doubleSelect`
  49. WHERE (Email IS NULL or Email NOT IN ('email@email.com'))
  50. AND (AddlEmail IS NULL or AddlEmail NOT IN ('email@email.com'))
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement