mysql 年月日不同字段 如何按照区间筛选

Question

mysql 年月日不同字段 如何按照区间筛选
如题 有趣的题 如何快速查询且准确

---

eg:

   id   month  day
    1     5     1
    2     5     6  
    3     6     19
    4     7     1
    5     7     2

筛选出5月6号-7月1号的id

Answer 1

mysql有字符串转时间和时间戳的函数 也有将多个字段拼接的函数拼接下转下格式 再比对区间参数

Answer 2

通用开始,中间连续,结束三段unionselect&nbsp;id&nbsp;from&nbsp;tbl&nbsp;where&nbsp;month&nbsp;=&nbsp;5&nbsp;and&nbsp;day&nbsp;>=&nbsp;6union&nbsp;select&nbsp;id&nbsp;from&nbsp;tbl&nbsp;where&nbsp;month&nbsp;>&nbsp;5&nbsp;and&nbsp;month&nbsp;<&nbsp;7union&nbsp;select&nbsp;id&nbsp;from&nbsp;tbl&nbsp;where&nbsp;month&nbsp;=&nbsp;7&nbsp;and&nbsp;day&nbsp;<=&nbsp;1针对特殊日期select&nbsp;id&nbsp;from&nbsp;tbl&nbsp;where&nbsp;month&nbsp;=&nbsp;5&nbsp;and&nbsp;day&nbsp;>=&nbsp;6union&nbsp;select&nbsp;id&nbsp;from&nbsp;tbl&nbsp;where&nbsp;month&nbsp;=&nbsp;6union&nbsp;select&nbsp;id&nbsp;from&nbsp;tbl&nbsp;where&nbsp;month&nbsp;=&nbsp;7&nbsp;and&nbsp;day&nbsp;=&nbsp;1