SQL错误/SORT-BY破坏了PHP - SQL Error / SORT BY breaks PHP

SQL Error / SORT BY breaks PHP

本文关键字：坏了 PHP SORT-BY 错误 SQL | 更新日期: 2024-04-03

我的第一个语句工作得很好，但我想订购该语句并以最高百分比返回结果1st[meta_value]

SELECT * FROM wp_postmeta WHERE meta_key = "win_percentage"
Array
(
    [0] => stdClass Object
        (
            [meta_id] => 417
            [post_id] => 59
            [meta_key] => win_percentage
            [meta_value] => 9.3023255814
        )
    [1] => stdClass Object
        (
            [meta_id] => 419
            [post_id] => 62
            [meta_key] => win_percentage
            [meta_value] => 6.66666666667
        )
)
SELECT * FROM wp_postmeta WHERE meta_key = "win_percentage" ORDER BY = meta_value ASC

故障

ORDER BY 后删除=

SELECT * FROM wp_postmeta WHERE meta_key = "win_percentage" ORDER BY meta_value ASC

读取http://dev.mysql.com/doc/refman/5.7/en/order-by-optimization.html

使用ORDER BY {COLUMN_NAME}而不是使用按.排序的=

SELECT * FROM wp_postmeta WHERE meta_key = "win_percentage" ORDER BY meta_value ASC