我想从wp_postmeta表中获取wordpress帖子数据和wp_attached_file这是我的SQL查询
$query= mysql_query("SELECT wp_posts.ID,wp_posts.post_title,wp_posts.post_date,wp_postmeta.meta_value
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_date > '$before7'
AND wp_posts.post_status = 'publish'
AND wp_posts.post_type = 'post'
AND wp_term_relationships.term_taxonomy_id = '$cat'
AND wp_postmeta.meta_key = '_wp_attached_file'
ORDER BY wp_posts.post_date DESC LIMIT 10");
它什么也没给我但是如果我从where子句中删除这行
AND wp_postmeta.meta_key = '_wp_attached_file'
可以,但我需要这行来获取wp_attached_file
那么mysql query
确保wp_postmeta。Meta_key与值_wp_attached_file确实存在,然后可能有一些问题匹配尝试修剪都导致隐藏字符
AND trim(wp_postmeta.meta_key) = trim('_wp_attached_file')