Advertisement
Guest User

Untitled

a guest
Mar 1st, 2019
995
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 ('[email protected]', '[email protected]')"
  11.  
  12. // example table data for 2 fields in question
  13. Row | Email | AddlEmail
  14.  
  15. CREATE TABLE `doubleSelect` (
  16. `Email` varchar(255) DEFAULT NULL,
  17. `AddlEmail` varchar(255) DEFAULT NULL
  18. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  19.  
  20. INSERT INTO `doubleSelect` (`Email`, `AddlEmail`) VALUES
  21. (NULL, '[email protected]'),
  22. ('[email protected]', NULL);
  23.  
  24. SELECT *
  25. FROM `doubleSelect`
  26. WHERE Email NOT
  27. IN (
  28. )
  29. AND AddlEmail NOT
  30. IN (
  31. )
  32.  
  33. AND e.Email NOT IN ('[email protected]', '[email protected]')
  34. AND e.AddlEmail NOT IN ('[email protected]', '[email protected]')
  35.  
  36. SELECT *
  37. FROM `doubleSelect`
  38. WHERE (Email IS NULL or Email NOT IN ('[email protected]'))
  39. AND (AddlEmail IS NULL or AddlEmail NOT IN ('[email protected]'))
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement