回答編集履歴
1
chousei
test
CHANGED
@@ -9,10 +9,6 @@
|
|
9
9
|
(5,'お',3,2);
|
10
10
|
|
11
11
|
select *,CONCAT_WS(',',
|
12
|
-
case field(a,1,2) when 0 then null else 'a' end,
|
13
|
-
case field(b,1,2) when 0 then null else 'b' end) as x from posts
|
14
|
-
|
15
|
-
select *,CONCAT_WS(',',
|
16
12
|
case when field(a,1,2)>0 then 'a' end,
|
17
13
|
case when field(b,1,2)>0 then 'b' end
|
18
14
|
) as roots from posts
|