如何查询数据库的中间值并按最接近的排序?
我正在 MySQL 数据库中搜索一个值,并希望按最接近的项目对结果进行排序。
示例:
我在查询中搜索值 150,现在执行以下操作:
SELECT * FROM table WHERE field BETWEEN 100 AND 200
100和200是之前通过简单的加减法计算出来的。但现在我的结果搞砸了,因为它返回的结果就像保存到数据库中一样。
是否可以在 MySQL 中对结果进行排序,或者我必须随后使用 PHP 对结果进行排序?
I'm searching a value in my MySQL-Database and want to sort the results by the nearest items.
Example:
I search for a value of 150, within my Query I now do the following:
SELECT * FROM table WHERE field BETWEEN 100 AND 200
The 100 and the 200 are calculated before by an easy addition and substraction. But now my results are messed up, because it gives me the results back like they were saved to the database.
Is it possible to sort the results within MySQL or do I have to sort them afterwards with PHP?
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(2)
您应该能够添加一个 order by 子句,如下所示:
you should be able to add an order by clause like so:
或者你想要类似的东西吗
?
不管怎样,有一些交互式在线 SQL 教程可以帮助您快速掌握 SQL 技能。
or did you want something like
?
Anyway, there are interactive online SQL tutorials which should help you jump start your SQL skills.