本文介绍了Wordpress WP_Query where子句带有OR?的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
朋友您好，这是我对WP_Query的参数.
hello friends this is my args for WP_Query.
$args = array('post_type' => 'job_listing');
$args['meta_query']=array(
'relation' => 'OR',
array(
'key' => 'app_trailer-type',
'value' => $job_tailor,
'compare' => 'LIKE'
),
array(
'key' => 'app_pay-type',
'value' => $app_pay_type,
'compare' => 'LIKE'
),
array(
'key' => 'geo_address',
'value' => $geo_address,
'compare' => 'LIKE'
),
array(
'key' => 'geo_country',
'value' => $geo_country,
'compare' => 'LIKE'
),
array(
'key' => 'geo_short_address',
'value' => $geo_short_address,
'compare' => 'LIKE'
),
);
这是返回查询之类.
SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts INNER JOIN wp_postmeta ON (wp_posts.ID = wp_postmeta.post_id)
INNER JOIN wp_postmeta AS mt1 ON (wp_posts.ID = mt1.post_id)
INNER JOIN wp_postmeta AS mt2 ON (wp_posts.ID = mt2.post_id)
INNER JOIN wp_postmeta AS mt3 ON (wp_posts.ID = mt3.post_id)
INNER JOIN wp_postmeta AS mt4 ON (wp_posts.ID = mt4.post_id) WHERE 1=1 AND wp_posts.post_type = 'job_listing' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'expired' OR wp_posts.post_status = 'tr_pending' OR wp_posts.post_status = 'tr_failed' OR wp_posts.post_status = 'tr_completed' OR wp_posts.post_status = 'tr_activated' OR wp_posts.post_status = 'private') AND ( (wp_postmeta.meta_key = 'app_trailer-type' AND CAST(wp_postmeta.meta_value AS CHAR) LIKE '%Flatbed%')
AND (mt1.meta_key = 'app_pay-type' AND CAST(mt1.meta_value AS CHAR) LIKE '%Per Week%')
AND (mt2.meta_key = 'geo_address' AND CAST(mt2.meta_value AS CHAR) LIKE '%Davenport%')
AND (mt3.meta_key = 'geo_country' AND CAST(mt3.meta_value AS CHAR) LIKE '%United States%')
AND (mt4.meta_key = 'geo_short_address' AND CAST(mt4.meta_value AS CHAR) LIKE '%Davenport%') ) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 10
我需要类似查询的查询.
i required query that query like.
SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts INNER JOIN wp_postmeta ON (wp_posts.ID = wp_postmeta.post_id)
INNER JOIN wp_postmeta AS mt1 ON (wp_posts.ID = mt1.post_id)
INNER JOIN wp_postmeta AS mt2 ON (wp_posts.ID = mt2.post_id)
INNER JOIN wp_postmeta AS mt3 ON (wp_posts.ID = mt3.post_id)
INNER JOIN wp_postmeta AS mt4 ON (wp_posts.ID = mt4.post_id) WHERE 1=1 AND wp_posts.post_type = 'job_listing' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'expired' OR wp_posts.post_status = 'tr_pending' OR wp_posts.post_status = 'tr_failed' OR wp_posts.post_status = 'tr_completed' OR wp_posts.post_status = 'tr_activated' OR wp_posts.post_status = 'private') AND ( (wp_postmeta.meta_key = 'app_trailer-type' OR CAST(wp_postmeta.meta_value AS CHAR) LIKE '%Flatbed%')
OR (mt1.meta_key = 'app_pay-type' AND CAST(mt1.meta_value AS CHAR) LIKE '%Per Week%')
OR (mt2.meta_key = 'geo_address' AND CAST(mt2.meta_value AS CHAR) LIKE '%Davenport%')
OR (mt3.meta_key = 'geo_country' AND CAST(mt3.meta_value AS CHAR) LIKE '%United States%')
OR (mt4.meta_key = 'geo_short_address' AND CAST(mt4.meta_value AS CHAR) LIKE '%Davenport%') ) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 10
请帮助.
推荐答案
用like更改了args.
changed args with like.
$args = array('post_type' => 'job_listing', 'relation' => 'OR');
$args['meta_query']=array(
array(
'key' => 'app_trailer-type',
'value' => $job_tailor,
'compare' => 'LIKE'
),
array(
'key' => 'app_pay-type',
'value' => $app_pay_type,
'compare' => 'LIKE'
),
array(
'key' => 'geo_address',
'value' => $geo_address,
'compare' => 'LIKE'
),
array(
'key' => 'geo_country',
'value' => $geo_country,
'compare' => 'LIKE'
),
array(
'key' => 'geo_short_address',
'value' => $geo_short_address,
'compare' => 'LIKE'
),
);
这篇关于Wordpress WP_Query where子句带有OR?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！