Mysql重复控制和空格
Mysql重复控制和空格
提问于 2018-06-04 16:41:23
您好，我尝试显示表中的所有重复项：
SELECT COUNT(*) AS nbr_doublon, nom, prenom, email
FROM table
GROUP BY nom, prenom, email
HAVING COUNT(*) > 1如何删除prenom和nom中的所有空格？
谢谢
回答 1
Stack Overflow用户
回答已采纳
发布于 2018-06-04 16:59:30
1-可以使用trim()
SELECT COUNT() AS nbr_doublon,
trim(nom) as nom,
trim(prenom) as prenom,
email
FROM table
GROUP BY trim(nom), trim(prenom), email
HAVING COUNT() > 12-但有时空格不在末尾，因此您需要使用replace：
SELECT COUNT() AS nbr_doublon,
REPLACE(trim(nom)," ","") as nom,
REPLACE(trim(prenom)," ","") as prenom,
email
FROM table
GROUP BY REPLACE(trim(nom)," ",""), REPLACE(trim(prenom)," ",""), email
HAVING COUNT() > 1页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/50676522
复制相关文章
相似问题