回答編集履歴
2
訂正
answer
CHANGED
|
@@ -11,6 +11,6 @@
|
|
|
11
11
|
```SQL
|
|
12
12
|
select * from items i where exists(
|
|
13
13
|
select 1 from weapons
|
|
14
|
-
where id=1 and JSON_CONTAINS(item,
|
|
14
|
+
where id=1 and JSON_CONTAINS(item, concat('[', i.id, ']'), '$.item_ids')
|
|
15
15
|
)
|
|
16
16
|
```
|
1
修正
answer
CHANGED
|
@@ -10,6 +10,7 @@
|
|
|
10
10
|
existsなら相関副問合せで同様の結果が得られると思います。
|
|
11
11
|
```SQL
|
|
12
12
|
select * from items i where exists(
|
|
13
|
+
select 1 from weapons
|
|
13
|
-
|
|
14
|
+
where id=1 and JSON_CONTAINS(item, cncat('[', i.id, ']'), '$.item_ids')
|
|
14
15
|
)
|
|
15
16
|
```
|