tag:blogger.com,1999:blog-2776726104235630005.post1646756741377518798..comments2023-09-09T01:18:28.875-07:00Comments on Life in University Information Technology: MySQL - find bad email addresses in databaseMBhttp://www.blogger.com/profile/14651890523678387870noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-2776726104235630005.post-70555198905447166102008-11-17T07:50:00.000-08:002008-11-17T07:50:00.000-08:00You mean you had *MOST* of the bad addresses."@." ...You mean you had *MOST* of the bad addresses.<BR/><BR/>"@." would slip past your query, as would "a@b.AReallyLongTLD". Same goes for invalid characters.<BR/><BR/>What you really should do is run the query using regular expression commands. Check out this MySQL regex tutorial: <A HREF="http://www.go4expert.com/forums/showthread.php?t=2337" REL="nofollow">www.go4expert.com/forums/showthread.php?tAnonymoushttps://www.blogger.com/profile/13252749182134476664noreply@blogger.com