mysql - WordPress 获取值之间的最大帖子元

Question

我已经有一个查询，例如:

SELECT max(cast(meta_value as unsigned)) AS max_racer_nr FROM wp_postmeta WHERE meta_key='racer_nr'

我需要获得介于 1 - 99 或 100 - 199 之间的最大 racer_nr ，或200 - 999，具体取决于赛车手所属的级别。

Answer 1

SELECT MAX(CAST(`meta_value` AS unsigned)) AS `max_racer_nr` FROM `wp_postmeta` WHERE `meta_key` = 'racer_nr' AND `meta_value` BETWEEN 1 AND 99; 

或

SELECT MAX(CAST(`meta_value` AS unsigned)) AS `max_racer_nr` FROM `wp_postmeta` WHERE `meta_key` = 'racer_nr' AND `meta_value` >= 1 AND `meta_value` <= 99; 

您只需根据赛车的类别更改 PHP 代码中的值即可。除非我误解了你的需要。