开发者

Wordpress SQL Questions

开发者 https://www.devze.com 2023-02-09 21:43 出处:网络
I have a problem, I would like to know how to combine this query to perform a search SELECT user_id FROM wp_usermeta

I have a problem, I would like to know how to combine this query to perform a search

SELECT user_id
FROM wp_usermeta
WHERE meta_key =  'g_State'
AND meta_value LIKE  '%Pahang%'

with

SELECT user_id
FROM wp_usermeta
WHERE meta_key =  'g_Categories'
AND meta_value LIKE  '%cat001%'
AND meta_value LIKE  '%cat002%'

is it possible to do it without changing the stru开发者_开发百科cture of the tables?


SELECT user_id 
FROM wp_usermeta 
WHERE (meta_key = 'g_State' AND meta_value LIKE '%Pahang%')
   OR (meta_key = 'g_Categories' AND 
       meta_value LIKE '%cat001%' AND meta_value LIKE '%cat002%')


If you want to combine the results, rewrite your where clause:

SELECT user_id FROM wp_usermeta WHERE (meta_key = 'g_State' AND meta_value LIKE '%Pahang%') OR (meta_key = 'g_Categories' AND meta_value LIKE '%cat001%' AND meta_value LIKE '%cat002%')


Try this.

SELECT user_id
FROM wp_usermeta
WHERE (meta_key =  'g_State'
AND meta_value LIKE  'Pahang' + '%')
OR
(meta_key =  'g_Categories'
AND meta_value LIKE  'cat001' + '%'
AND meta_value LIKE  'cat002%' + '%')
0

精彩评论

暂无评论...
验证码 换一张
取 消