質問編集履歴
4
あ
test
CHANGED
File without changes
|
test
CHANGED
@@ -44,41 +44,41 @@
|
|
44
44
|
|
45
45
|
|
46
46
|
|
47
|
-
insert table_name (id, sei, mei) VALUE (1, '
|
47
|
+
insert table_name (id, sei, mei) VALUE (1, '田中', '二郎');
|
48
48
|
|
49
|
-
insert table_name (id, sei, mei) VALUE (2, '
|
49
|
+
insert table_name (id, sei, mei) VALUE (2, '田中', '二郎2');
|
50
50
|
|
51
|
-
insert table_name (id, sei, mei) VALUE (3, '
|
51
|
+
insert table_name (id, sei, mei) VALUE (3, '田中', '二郎3');
|
52
52
|
|
53
|
-
insert table_name (id, sei, mei) VALUE (4, '
|
53
|
+
insert table_name (id, sei, mei) VALUE (4, '田中', '二郎4');
|
54
54
|
|
55
|
-
insert table_name (id, sei, mei) VALUE (5, '
|
55
|
+
insert table_name (id, sei, mei) VALUE (5, '高橋', '太郎');
|
56
56
|
|
57
|
-
insert table_name (id, sei, mei) VALUE (6, '
|
57
|
+
insert table_name (id, sei, mei) VALUE (6, '高橋', '太郎2');
|
58
58
|
|
59
|
-
insert table_name (id, sei, mei) VALUE (7, '
|
59
|
+
insert table_name (id, sei, mei) VALUE (7, '高橋', '太郎3');
|
60
60
|
|
61
|
-
insert table_name (id, sei, mei) VALUE (8, '
|
61
|
+
insert table_name (id, sei, mei) VALUE (8, '高橋', '太郎4');
|
62
62
|
|
63
|
-
insert table_name (id, sei, mei) VALUE (9, '
|
63
|
+
insert table_name (id, sei, mei) VALUE (9, '斎藤2', '一郎9');
|
64
64
|
|
65
|
-
insert table_name (id, sei, mei) VALUE (10, '
|
65
|
+
insert table_name (id, sei, mei) VALUE (10, '斎藤2', '一郎');
|
66
66
|
|
67
|
-
insert table_name (id, sei, mei) VALUE (11, '
|
67
|
+
insert table_name (id, sei, mei) VALUE (11, '斎藤2', '一郎2');
|
68
68
|
|
69
|
-
insert table_name (id, sei, mei) VALUE (12, '
|
69
|
+
insert table_name (id, sei, mei) VALUE (12, '斎藤2', '一郎3');
|
70
70
|
|
71
|
-
insert table_name (id, sei, mei) VALUE (13, '
|
71
|
+
insert table_name (id, sei, mei) VALUE (13, '佐藤2', '四郎');
|
72
72
|
|
73
|
-
insert table_name (id, sei, mei) VALUE (14, '
|
73
|
+
insert table_name (id, sei, mei) VALUE (14, '佐藤2', '四郎2');
|
74
74
|
|
75
|
-
insert table_name (id, sei, mei) VALUE (15, '
|
75
|
+
insert table_name (id, sei, mei) VALUE (15, '佐藤2', '四郎3');
|
76
76
|
|
77
|
-
insert table_name (id, sei, mei) VALUE (16, '
|
77
|
+
insert table_name (id, sei, mei) VALUE (16, '佐藤2', '四郎4');
|
78
78
|
|
79
|
-
insert table_name (id, sei, mei) VALUE (17, '
|
79
|
+
insert table_name (id, sei, mei) VALUE (17, '佐藤2', '四郎5');
|
80
80
|
|
81
|
-
insert table_name (id, sei, mei) VALUE (18, '
|
81
|
+
insert table_name (id, sei, mei) VALUE (18, '佐藤2', '四郎6');
|
82
82
|
|
83
83
|
|
84
84
|
|
@@ -132,9 +132,13 @@
|
|
132
132
|
|
133
133
|
|:--|:--:|--:|
|
134
134
|
|
135
|
-
|1|
|
135
|
+
|1|田中二郎|4|
|
136
136
|
|
137
|
-
|10|
|
137
|
+
|10|高橋2太郎|4|
|
138
|
+
|
139
|
+
|1|斎藤2一郎|4|
|
140
|
+
|
141
|
+
|10|佐藤2四郎|5|
|
138
142
|
|
139
143
|
|
140
144
|
|
@@ -144,7 +148,7 @@
|
|
144
148
|
|
145
149
|
sei : が完全一致
|
146
150
|
|
147
|
-
mei :
|
151
|
+
mei : 前方一致
|
148
152
|
|
149
153
|
```
|
150
154
|
|
3
a
test
CHANGED
File without changes
|
test
CHANGED
@@ -128,7 +128,7 @@
|
|
128
128
|
|
129
129
|
|
130
130
|
|
131
|
-
|id|
|
131
|
+
|id|fullname|count|
|
132
132
|
|
133
133
|
|:--|:--:|--:|
|
134
134
|
|
2
a
test
CHANGED
File without changes
|
test
CHANGED
@@ -60,25 +60,25 @@
|
|
60
60
|
|
61
61
|
insert table_name (id, sei, mei) VALUE (8, '名前', '苗字8');
|
62
62
|
|
63
|
-
insert table_name (id, sei, mei) VALUE (9, '名前', '苗字9');
|
63
|
+
insert table_name (id, sei, mei) VALUE (9, '名前2', '苗字9');
|
64
64
|
|
65
|
-
insert table_name (id, sei, mei) VALUE (10, '名前', '苗字
|
65
|
+
insert table_name (id, sei, mei) VALUE (10, '名前2', '苗字');
|
66
66
|
|
67
|
-
insert table_name (id, sei, mei) VALUE (11, '名前', '苗字
|
67
|
+
insert table_name (id, sei, mei) VALUE (11, '名前2', '苗字2');
|
68
68
|
|
69
|
-
insert table_name (id, sei, mei) VALUE (12, '名前', '苗字
|
69
|
+
insert table_name (id, sei, mei) VALUE (12, '名前2', '苗字3');
|
70
70
|
|
71
|
-
insert table_name (id, sei, mei) VALUE (13, '名前', '苗字
|
71
|
+
insert table_name (id, sei, mei) VALUE (13, '名前2', '苗字4');
|
72
72
|
|
73
|
-
insert table_name (id, sei, mei) VALUE (14, '名前', '苗字
|
73
|
+
insert table_name (id, sei, mei) VALUE (14, '名前2', '苗字5');
|
74
74
|
|
75
|
-
insert table_name (id, sei, mei) VALUE (15, '名前', '苗字
|
75
|
+
insert table_name (id, sei, mei) VALUE (15, '名前2', '苗字6');
|
76
76
|
|
77
|
-
insert table_name (id, sei, mei) VALUE (16, '名前', '苗字
|
77
|
+
insert table_name (id, sei, mei) VALUE (16, '名前2', '苗字7');
|
78
78
|
|
79
|
-
insert table_name (id, sei, mei) VALUE (17, '名前', '苗字
|
79
|
+
insert table_name (id, sei, mei) VALUE (17, '名前2', '苗字8');
|
80
80
|
|
81
|
-
insert table_name (id, sei, mei) VALUE (18, '名前', '苗字
|
81
|
+
insert table_name (id, sei, mei) VALUE (18, '名前2', '苗字9');
|
82
82
|
|
83
83
|
|
84
84
|
|
@@ -110,7 +110,9 @@
|
|
110
110
|
|
111
111
|
SELECT
|
112
112
|
|
113
|
-
CONCAT(sei, mei) as fullname
|
113
|
+
CONCAT(sei, mei) as fullname,
|
114
|
+
|
115
|
+
count(fullname) as count
|
114
116
|
|
115
117
|
FROM table_name
|
116
118
|
|
@@ -124,9 +126,25 @@
|
|
124
126
|
|
125
127
|
### 期待値
|
126
128
|
|
129
|
+
|
130
|
+
|
131
|
+
|id||fullname|count|
|
132
|
+
|
133
|
+
|:--|:--:|--:|
|
134
|
+
|
135
|
+
|1|名前苗字|9|
|
136
|
+
|
137
|
+
|10|名前2苗字|9|
|
138
|
+
|
139
|
+
|
140
|
+
|
141
|
+
・条件
|
142
|
+
|
127
143
|
```
|
128
144
|
|
129
|
-
|
145
|
+
sei : が完全一致
|
146
|
+
|
147
|
+
mei : 部分一致
|
130
148
|
|
131
149
|
```
|
132
150
|
|
1
mysql
test
CHANGED
File without changes
|
test
CHANGED
@@ -5,6 +5,14 @@
|
|
5
5
|
SQLでの名前のあいまい検索で重複を探したいです。
|
6
6
|
|
7
7
|
|
8
|
+
|
9
|
+
|
10
|
+
|
11
|
+
### バージョン
|
12
|
+
|
13
|
+
mysql
|
14
|
+
|
15
|
+
5.7.22
|
8
16
|
|
9
17
|
|
10
18
|
|