MySQL中的UNION和ORDER BY问题 [英] UNION and ORDER BY issue in MySQL

问题描述

您应该在这里看到我正在尝试执行的操作，但是它不起作用

You should see what I'm trying to do here but it's not working

$getquery = "SELECT * 
FROM highscore 
WHERE score >= '$score'
ORDER BY score ASC
LIMIT 6

UNION

SELECT * 
FROM highscore 
WHERE score < '$score'
ORDER BY score DESC
LIMIT 5";

mysql_error()返回:不正确使用ORDER BY和UNION".

mysql_error() returns: "improper usage of ORDER BY and UNION".

推荐答案

尝试:

$getquery = "(SELECT * 
FROM highscore 
WHERE score >= '$score'
ORDER BY score ASC
LIMIT 6)

UNION ALL -- guaranteed to be beneficial in this case as Johan commented

(SELECT * 
FROM highscore 
WHERE score < '$score'
ORDER BY score DESC
LIMIT 5)";

请参阅对我的评论回答相关问题.
或咨询详细手册.

See the comments to my answer on the related question.
Or consult the fine manual.

这篇关于MySQL中的UNION和ORDER BY问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！