Sql script to find invalid email addresses

by 
SELECT * FROM people WHERE email NOT LIKE '%_@__%.__%'

Anything more complex will likely return false negatives and run slower.

Validating e-mail addresses in code is virtually impossible.

EDIT: Related questions

More Related Contents:

  1. T-SQL: checking for email format
  2. Query database then email posts from where user is subbed to
  3. Select rows which are not present in other table
  4. How to calculate age (in years) based on Date of Birth and getDate()
  5. How to implement a many-to-many relationship in PostgreSQL?
  6. Combining “LIKE” and “IN” for SQL Server [duplicate]
  7. What is the difference between JOIN and UNION?
  8. sql statement error: “column .. does not exist”
  9. Oracle: What does `(+)` do in a WHERE clause?
  10. Sorting null values after all others, except special
  11. Concatenate results from a SQL query in Oracle
  12. Can I do a max(count(*)) in SQL?
  13. Which SQL query is better, MATCH AGAINST or LIKE?
  14. How to convert comma separated NVARCHAR to table records in SQL Server 2005?
  15. SQL Server: drop table cascade equivalent?
  16. SQL Server converting varbinary to string
  17. SPARK SQL – case when then
  18. Sqlite: CURRENT_TIMESTAMP is in GMT, not the timezone of the machine
  19. How to fill date gaps in MySQL?
  20. ORA – 00933 confusion with inner join and “as”
  21. Ad hoc queries vs stored procedures vs Dynamic SQL [closed]
  22. Function for week of the month in mysql
  23. Comparing with date in Oracle sql
  24. SQL selecting rows by most recent date with two unique columns
  25. Insert Update stored proc on SQL Server
  26. How to extract group from regular expression in Oracle?
  27. TSQL – How to use GO inside of a BEGIN .. END block?
  28. Rails find record with zero has_many records associated [duplicate]
  29. ORA-00942: table or view does not exist (works when a separate sql, but does not work inside a oracle function)
  30. Return rows from INSERT with ON CONFLICT without needing to update

Leave a Comment