我使用WP_QUERY来获取帖子。问题是,我想按标题排序的帖子,但有些事情是错误的。我可以得到的帖子,但没有排序。
我跟踪了WP_QUERY类,我发现这是它产生的选择查询
SELECT SQL_CALC_FOUND_ROWS wp_posts . *
FROM wp_posts
INNER JOIN wp_term_relationships ON ( wp_posts.ID = wp_term_relationships.object_id )
WHERE 1 =1
AND (
wp_term_relationships.term_taxonomy_id
IN ( 4, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16 )
)
AND wp_posts.post_type = 'ecommerce'
AND (
wp_posts.post_status = 'publish'
OR wp_posts.post_status = 'private'
)
GROUP BY wp_posts.ID
ORDER BY `wp_posts`.`post_title` ASC
LIMIT 0 , 10
很明显,它是按标题正确排序的,但我不确定是什么问题
有什么帮助吗?
谢谢
可能有些标题的左边字符有空格。你可以试试:
ORDER BY LTRIM(wp_posts.post_title) ASC