回答編集履歴
1
文字列じゃなかった・・・
answer
CHANGED
|
@@ -1,8 +1,8 @@
|
|
|
1
1
|
設計を変えられないんでしょうかね？
|
|
2
2
|
```SQL
|
|
3
3
|
SELECT *,
|
|
4
|
-
DATE(
|
|
4
|
+
DATE(CONCAT_WS('-', start_year, start_month, start_day)) AS start_date,
|
|
5
|
-
DATE(
|
|
5
|
+
DATE(CONCAT_WS('-', end_year, end_month, end_day)) AS end_date
|
|
6
6
|
FROM テーブル名
|
|
7
7
|
WHERE start_date BETWEEN '2016-06-22' AND '2017-07-28'
|
|
8
8
|
AND end_date BETWEEN '2016-06-22' AND '2017-07-28';
|