回答編集履歴
1
chousei
test
CHANGED
|
@@ -1,6 +1,6 @@
|
|
|
1
1
|
```SQL
|
|
2
2
|
|
|
3
|
-
create table customers(id int primary key,name varchar(20),address json);
|
|
3
|
+
create table customers(id int primary key,name varchar(20),addresses json);
|
|
4
4
|
|
|
5
5
|
insert into customers values
|
|
6
6
|
|
|
@@ -12,6 +12,6 @@
|
|
|
12
12
|
|
|
13
13
|
|
|
14
14
|
|
|
15
|
-
select * from customers where json_contains(address->"$[*].province", '"北海道"');
|
|
15
|
+
select * from customers where json_contains(addresses->"$[*].province", '"北海道"');
|
|
16
16
|
|
|
17
17
|
```
|