mysql order by值相同_在MySQL中ORDER BY一个相等的值

所有,

我现在有以下SQL查询：

SELECT * FROM $wpdb->posts

JOIN $wpdb->term_relationships ON $wpdb->term_relationships.object_id=$wpdb->posts.ID

JOIN $wpdb->postmeta ON $wpdb->postmeta.post_id=$wpdb->posts.ID

WHERE

$wpdb->posts.post_status = 'publish'

AND $wpdb->posts.post_type = 'post'

AND $wpdb->term_relationships.term_taxonomy_id='$vendor_category_to_use'

AND $wpdb->postmeta.meta_key='zip'

我有一个名为featuremeta.meta_key的特色.然后,如果帖子的特色是在另一个名为postmeta.meta_value的列中.如果meta_value =“yes”,其中meta_key等于“featured”,那么我想首先显示这个,然后显示其余的帖子.我怎么能这样做呢？

编辑：这是数据设置：

postid meta_key meta_value

123 featured yes

324 featured no

182 featured yes

873 featured yes

所以在这个例子中,我希望我的帖子按此顺序显示：

postid meta_key meta_value

123 featured yes

182 featured yes

873 featured yes

324 featured no

我希望有所帮助！

这是生成的SQL：

SELECT *

FROM wp_posts

JOIN wp_term_relationships ON wp_term_relationships.object_id=wp_posts.ID

JOIN wp_postmeta ON wp_postmeta.post_id=wp_posts.ID

WHERE wp_posts.post_status = 'publish' AND wp_posts.post_type = 'post' AND wp_term_relationships.term_taxonomy_id='5' AND wp_postmeta.meta_key='zip' AND (wp_postmeta.meta_value = '46320' OR wp_postmeta.meta_value = '46321' OR wp_postmeta.meta_value = '46322' OR wp_postmeta.meta_value = '46323' OR wp_postmeta.meta_value = '46324' OR wp_postmeta.meta_value = '46327' OR wp_postmeta.meta_value = '46394' OR wp_postmeta.meta_value = '46402' OR wp_postmeta.meta_value = '46404' )

ORDER BY (wp_postmeta.meta_key='featured' AND wp_postmeta.meta_value='yes') DESC, wp_posts.post_date DESC

谢谢！