質問編集履歴
5
aaaaaa
title
CHANGED
@@ -1,1 +1,1 @@
|
|
1
|
-
MySQLでのSELECTした
|
1
|
+
MySQLでのSELECTで名前変更したものをを検索する方法。
|
body
CHANGED
@@ -1,6 +1,6 @@
|
|
1
1
|
### 前提・実現したいこと
|
2
2
|
|
3
|
-
SQLでSELECTで変更した値を検索したい。
|
3
|
+
SQLでSELECTで名前を変更した値を検索したい。
|
4
4
|
|
5
5
|
|
6
6
|
### 該当のソースコード
|
@@ -12,16 +12,16 @@
|
|
12
12
|
WHEN gender = '男' THEN 1
|
13
13
|
WHEN gender = null THEN 2
|
14
14
|
ELSE 99
|
15
|
-
END as
|
15
|
+
END as gender1
|
16
|
-
FROM users where
|
16
|
+
FROM users where gender1 = 2
|
17
17
|
|
18
18
|
SELECT
|
19
19
|
IF(
|
20
20
|
gender = null, gender = 2,
|
21
21
|
gender
|
22
|
-
)
|
22
|
+
) gender1
|
23
23
|
FROM users
|
24
|
-
where
|
24
|
+
where gender1 = 2;
|
25
25
|
|
26
26
|
|
27
27
|
create table users
|
@@ -58,4 +58,16 @@
|
|
58
58
|
|14|null|
|
59
59
|
|15|null|
|
60
60
|
|
61
|
-
### ご教授ください。
|
61
|
+
### ご教授ください。
|
62
|
+
|
63
|
+
|
64
|
+
|
65
|
+
### 追記
|
66
|
+
|
67
|
+
```
|
68
|
+
SELECT
|
69
|
+
gender as g1
|
70
|
+
FROM users
|
71
|
+
where g1 is null;
|
72
|
+
|
73
|
+
```
|
4
あああああ
title
CHANGED
File without changes
|
body
CHANGED
@@ -49,4 +49,13 @@
|
|
49
49
|
INSERT INTO users (gender) VALUES (null);
|
50
50
|
```
|
51
51
|
|
52
|
+
# 期待値
|
53
|
+
|id|gender|
|
54
|
+
|:--|:--:|
|
55
|
+
|11|null|
|
56
|
+
|12|null|
|
57
|
+
|13|null|
|
58
|
+
|14|null|
|
59
|
+
|15|null|
|
60
|
+
|
52
61
|
### ご教授ください。
|
3
SELECT IF( gender = null, gender = 2, gender ) gender FROM users where gender = 2;
title
CHANGED
File without changes
|
body
CHANGED
@@ -15,7 +15,15 @@
|
|
15
15
|
END as gender
|
16
16
|
FROM users where gender = 2
|
17
17
|
|
18
|
+
SELECT
|
19
|
+
IF(
|
20
|
+
gender = null, gender = 2,
|
21
|
+
gender
|
22
|
+
) gender
|
23
|
+
FROM users
|
24
|
+
where gender = 2;
|
18
25
|
|
26
|
+
|
19
27
|
create table users
|
20
28
|
(
|
21
29
|
id int auto_increment
|
2
MySQL
title
CHANGED
@@ -1,1 +1,1 @@
|
|
1
|
-
|
1
|
+
MySQLでのSELECTした値を検索する方法。
|
body
CHANGED
File without changes
|
1
sssss
title
CHANGED
File without changes
|
body
CHANGED
@@ -13,7 +13,7 @@
|
|
13
13
|
WHEN gender = null THEN 2
|
14
14
|
ELSE 99
|
15
15
|
END as gender
|
16
|
-
FROM
|
16
|
+
FROM users where gender = 2
|
17
17
|
|
18
18
|
|
19
19
|
create table users
|