Question

Closed. This question needs details or clarity. It is not currently accepting answers.

想要改进这个问题吗? 添加细节,并通过

我有一张下桌的桌子

Id     Avatar
1      Smarty.resident
2      ticklethis.resident
3      Renae resident
4      ticklethis
5      Smarty resident
6      Hirpantemp
7      loveyoubaby
8      Hirpantemp.resident
9      Renae
10     Sweetme
11     ticklethis resident

我无法写入 SQL 命令, 以获得类似的名称, 如以下的名称

Id     Avatar
1      Smarty.resident
5      Smarty resident
2      ticklethis.resident
4      ticklethis
11     ticklethis resident
3      Renae resident
9      Renae
6      Hirpantemp
8      Hirpantemp.resident

Answer 1

替换时的假设对此有点可疑, 但对于特定的数据集可能有用:

select ID, Avatar
from MyTable
where replace(replace(Avatar,  .resident ,   ),   resident ,   ) in (
    select replace(replace(Avatar,  .resident ,   ),   resident ,   ) as Avatar
    from MyTable
    group by replace(replace(Avatar,  .resident ,   ),   resident ,   )
    having count(*) > 1
)

友情链接