[ Date Index ][
Thread Index ]
[ <= Previous by date /
thread ]
[ Next by date /
thread => ]
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Thursday 18 July 2002 9:01 pm, Simon Waters wrote:
SELECT * FROM users WHERE clue > 0I decided it was rather geekish to point out the missing semicolon, not that I ever had much street cred, but now someone else has pointed it out when can we expect a patch ;)
Please find enclosed patch. I propose for speed you remove all Users who have null clue at all first. This should remove 99.78% of the users immediatly, letting you select only on the reamining few that acually have a clue greater than 0. (assuming the clue column allows null, which is more than likly with the widespread stupidity that exists in the wild today). - -SELECT * FROM users WHERE clue > 0 +SELECT * FROM users WHERE (clue != NULL AND clue > 0); ;) ~ Theo - -- Theo Zourzouvillys http://zozo.org.uk/ Q: How do you play religious roulette? A: You stand around in a circle and blaspheme and see who gets struck by lightning first. -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.7 (GNU/Linux) iD8DBQE9NyBE448CrwpTn6YRAi1rAKDl5VNQ+eKCp0CZRMwfoZcrGsK9IACfW4xI Gt5wSuxKKeilbAimSeXvqTM= =OHz4 -----END PGP SIGNATURE----- -- The Mailing List for the Devon & Cornwall LUG Mail majordomo@xxxxxxxxxxxx with "unsubscribe list" in the message body to unsubscribe.