質問編集履歴
1
うーん
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -40,4 +40,14 @@
|
|
|
40
40
|
(2, '山田', 'Yamada')
|
|
41
41
|
;
|
|
42
42
|
|
|
43
|
+
```
|
|
44
|
+
こうとか...うーん、PHPでやるしかないでしょうか。
|
|
45
|
+
```sql
|
|
46
|
+
SELECT
|
|
47
|
+
u.id,
|
|
48
|
+
u.old,
|
|
49
|
+
'[{ja:' . n.ja . '},{en:' . n.en . '}]' AS names
|
|
50
|
+
FROM users u
|
|
51
|
+
LEFT JOIN names n ON n.id=u.id
|
|
52
|
+
WHERE u.old > 10
|
|
43
53
|
```
|