On Thu, Oct 20, 2005 at 09:54:13PM +0300, Andrus wrote:
> How to write a WHERE clause which selects e-mail addresses which
> are surely wrong ?
Then I think the validating function someone else sent here
(<http://www.databasejournal.com/img/email_val.sql>) is a good start.
You probably want the opposite behaviour -- emailinvalidate(), I
guess -- but that seems like a good "obviously wrong" tester. It
might not be fast, though -- that loop at the special character
check looks pretty painful.
A
--
Andrew Sullivan | ajs@crankycanuck.ca
The fact that technology doesn't work is no bar to success in the marketplace.
--Philip Greenspun