MySQL missing email address query

Question

我有一个表（datas）：

line	account	name	email
1	1000	Reyes VonRueden Sr.	sharon51@yahooo.com
1	1000	Dr. Elena Bartell V
1	1000	Lucio Wehner
2	1000	April Hansen
2	1000	Amy Waelchi	hegmann.khalid@yahooo.com
2	1000	Tremaine Cassin
3	1000	Susana White Jr.	jfay@hotmailses.com
3	1000	Roxane Hoeger
3	1000	Prof. Eric Boehm
4	1000	Miles Considine	** **
4	1000	Araceli Effertz	** **
4	1000	Prof. Adolph Pacocha	** **
5	1000	Prof. Rafaela Hills	sydney20@gradyesses.com
5	1000	Delta Becker
5	1000	Aditya Ratke	julian28@yahooes.com
6	1000	Miss Elaina Aufderhar Sr.	royal.predovic@connellyses.com
6	1000	Miss Stephanie Russel IV
6	1000	Dr. Ramiro Marks IV	wrice@yahooes.com
7	1000	Garfield Kozey	** **
7	1000	Gene Hilpert	** **

线路和账户字段清楚地定义了一个客户。

姓名字段是一个工人。

我正在寻找没有电子邮件地址的客户（线路+账户）。

在这种情况下，结果是：4-1000和7-1000。

我可以用两个查询和Excel来解决这个问题，但在MySQL中会更快。

如果您能帮忙，谢谢；）

Answer 1

This is the query you are looking for.

SELECT * FROM customer WHERE email IS NULL or email = '';

This query will give you all fields without email.

If you are looking for records without a valid email address, use the following query.

SELECT * FROM customer WHERE email not like '%@%';