blocks|key|674780|text|您必须像您所说的那样使用OR，因为道布列的不能同时具有两个不同的值。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|BOLD|entityRanges|data|674781|`dob`+<+956485529+AND+`dob`+>+924863129|code-block|syntax|javascript|674782|或者，您可以尝试将时间戳转换为年份：|674783|SELECT
++FROM_UNIXTIME(my_unix_timestamp_column,+'%25Y')+AS+year
FROM
++table_name
WHERE
++FROM_UNIXTIME(my_unix_timestamp_column,+'%25Y')+=+2009;|674784|并尝试这个(当然，调整您的查询)|674785|entityMap^0|C|2|L|D|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|T|8|@$9|U|A|V|B|C]|$9|W|A|X|B|D]]|E|@]|F|$]]|$1|G|3|H|5|I|7|Y|8|@]|E|@]|F|$J|K]]|$1|L|3|M|5|6|7|Z|8|@]|E|@]|F|$]]|$1|N|3|O|5|I|7|10|8|@]|E|@]|F|$J|K]]|$1|P|3|Q|5|6|7|11|8|@]|E|@]|F|$]]|$1|R|3|-4|5|6|7|12|8|@]|E|@]|F|$]]]|S|$]]

You have to use <code>OR</code> like you said because dob column cannot have at the same time two different values.

<pre><code>`dob` &lt; 956485529 AND `dob` &gt; 924863129
</code></pre>

Or you can try to convert timestamp to year:

<pre><code>SELECT
 FROM_UNIXTIME(my_unix_timestamp_column, '%Y') AS year
FROM
 table_name
WHERE
 FROM_UNIXTIME(my_unix_timestamp_column, '%Y') = 2009;
</code></pre>

and play with this (of course, adapting your query)

blocks|key|674802|text|我会使用BETWEEN条件：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|674803|SELECT+*+FROM+(`users`)+WHERE+`dob`+BETWEEN+924863129+AND+956485529|code-block|syntax|javascript|674804|另外，我推荐使用TIMESTAMP数据类型。这样，您就可以执行以下操作：|offset|length|674805|SELECT+*+FROM+(`users`)+WHERE+`dob`+BETWEEN+DATE_SUB(NOW(),+INTERVAL+12+YEAR)+AND+DATE_SUB(NOW(),+INTERVAL+11+YEAR)|674806|这里有更多的例子：http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html|674807|entityMap|0|LINK|mutability|MUTABLE|url|http://dev.mysql.com/doc/refman/5.5/en/datetime.html|1|http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html^0|0|0|8|9|0|0|0|9|1V|1|0^^$0|@$1|2|3|4|5|6|7|Y|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|Z|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|10|8|@]|9|@$I|11|J|12|1|13]]|A|$]]|$1|K|3|L|5|D|7|14|8|@]|9|@]|A|$E|F]]|$1|M|3|N|5|6|7|15|8|@]|9|@$I|16|J|17|1|18]]|A|$]]|$1|O|3|-4|5|6|7|19|8|@]|9|@]|A|$]]]|P|$Q|$5|R|S|T|A|$U|V]]|W|$5|R|S|T|A|$U|X]]]]

I'd use the BETWEEN condition:

<pre><code>SELECT * FROM (`users`) WHERE `dob` BETWEEN 924863129 AND 956485529
</code></pre>

Also, i'd recommend the <a href="http://dev.mysql.com/doc/refman/5.5/en/datetime.html" rel="nofollow">TIMESTAMP</a> datatype. With that, you can do the following:

<pre><code>SELECT * FROM (`users`) WHERE `dob` BETWEEN DATE_SUB(NOW(), INTERVAL 12 YEAR) AND DATE_SUB(NOW(), INTERVAL 11 YEAR)
</code></pre>

More examples are here: <a href="http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html" rel="nofollow">http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html</a>

blocks|key|4457437|text|我读到您可以更改您的道布类型。|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|4457438|好的，如果您将其更改为DATETIME+(并修改该列中的值以将出生日期存储为DATETIME)，您可以尝试这样做：|4457439|select+*+FROM+users++
WHERE+(dob>DATE_SUB(NOW(),INTERVAL+13+YEAR))+
++AND+(dob<=DATE_SUB(NOW(),INTERVAL+11+YEAR));|code-block|syntax|javascript|4457440|entityMap^0|A|2|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@$9|P|A|Q|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|R|8|@]|D|@]|E|$]]|$1|H|3|I|5|J|7|S|8|@]|D|@]|E|$K|L]]|$1|M|3|-4|5|6|7|T|8|@]|D|@]|E|$]]]|N|$]]

I read that you can change your dob type. 
Ok, so if you change it to DATETIME (and modify the values in that column to store date of birth as a DATETIME) you could try this:

<pre><code>select * FROM users 
WHERE (dob&gt;DATE_SUB(NOW(),INTERVAL 13 YEAR)) 
 AND (dob&lt;=DATE_SUB(NOW(),INTERVAL 11 YEAR));
</code></pre>

blocks|key|4457466|text|SELECT+*+FROM+(`users`)+WHERE+`dob`+<+956485529+AND+`dob`+>+924863129|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|4457467|它只返回11岁的用户，因为：|unstyled|4457468|mysql>+select+FROM_UNIXTIME(924863129),+CURRENT_TIMESTAMP();
%2B--------------------------%2B---------------------%2B
%7C+FROM_UNIXTIME(924863129)+%7C+CURRENT_TIMESTAMP()+%7C
%2B--------------------------%2B---------------------%2B
%7C+1999-04-23+18:25:29++++++%7C+2011-04-23+22:06:50+%7C
%2B--------------------------%2B---------------------%2B

mysql>+select+FROM_UNIXTIME(956485529),+CURRENT_TIMESTAMP();
%2B--------------------------%2B---------------------%2B
%7C+FROM_UNIXTIME(956485529)+%7C+CURRENT_TIMESTAMP()+%7C
%2B--------------------------%2B---------------------%2B
%7C+2000-04-23+18:25:29++++++%7C+2011-04-23+22:07:19+%7C
%2B--------------------------%2B---------------------%2B|4457469|今天是2011-04-23！2011-04-23+-+1999-04-23+=+12！|4457470|所以你应该像这样写你的查询：|4457471|SELECT+*+FROM+(`users`)+WHERE+`dob`+<+956485529+AND+`dob`+>=+924863129|4457472|希望这对你有所帮助！|4457473|entityMap^0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|T|8|@]|9|@]|A|$]]|$1|G|3|H|5|6|7|U|8|@]|9|@]|A|$B|C]]|$1|I|3|J|5|F|7|V|8|@]|9|@]|A|$]]|$1|K|3|L|5|F|7|W|8|@]|9|@]|A|$]]|$1|M|3|N|5|6|7|X|8|@]|9|@]|A|$B|C]]|$1|O|3|P|5|F|7|Y|8|@]|9|@]|A|$]]|$1|Q|3|-4|5|F|7|Z|8|@]|9|@]|A|$]]]|R|$]]

<pre><code>SELECT * FROM (`users`) WHERE `dob` &lt; 956485529 AND `dob` &gt; 924863129
</code></pre>

it just return 11 years old users, because of:

<pre><code>mysql&gt; select FROM_UNIXTIME(924863129), CURRENT_TIMESTAMP();
+--------------------------+---------------------+
| FROM_UNIXTIME(924863129) | CURRENT_TIMESTAMP() |
+--------------------------+---------------------+
| 1999-04-23 18:25:29 | 2011-04-23 22:06:50 |
+--------------------------+---------------------+

mysql&gt; select FROM_UNIXTIME(956485529), CURRENT_TIMESTAMP();
+--------------------------+---------------------+
| FROM_UNIXTIME(956485529) | CURRENT_TIMESTAMP() |
+--------------------------+---------------------+
| 2000-04-23 18:25:29 | 2011-04-23 22:07:19 |
+--------------------------+---------------------+
</code></pre>

today is 2011-04-23! 
2011-04-23 - 1999-04-23 = 12!

so you should write you query like this:

<pre><code>SELECT * FROM (`users`) WHERE `dob` &lt; 956485529 AND `dob` &gt;= 924863129
</code></pre>

hope this help!

Basic query question but can't seem to get this right. I'm trying to find users that are 11 or 12 years old. DOB is stored as a timestamp

timestamp for "11 years ago" is 956485529

timestamp for "12 years ago" is 924863129

Query:

<pre><code>SELECT * FROM (`users`) WHERE `dob` &lt; 956485529 AND `dob` &gt; 924863129
</code></pre>

Seems to only return users that are 11 years old, and not the 12 year olds. What am I doing wrong?

Mysql, selecting users in a age range

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

基本的查询问题，但似乎不能正确回答。我正在努力寻找11岁或12岁的用户。将道布存储为时间戳"11年前“的时间戳是956485529"12年前“的时间戳是924863129查询：SELECT * FROM (`users`) WHERE `dob` < 956485529 AND `dob` > 924863129似乎只...

问Mysql，选择年龄范围内的用户
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问Mysql，选择年龄范围内的用户EN