mysql多个条件查询_MySQL选择查询具有多个条件

I have written a MySQL query but it doesn't seem to be working, because the result is empty. Is there any mistake in my code?

$result = mysql_query(

"SELECT user_id

FROM wp_usermeta

WHERE

(meta_key = 'first_name' AND meta_value = '$us_name') AND

(meta_key = 'yearofpassing' AND meta_value = '$us_yearselect') AND

(meta_key = 'u_city' AND meta_value = '$us_reg') AND

(meta_key = 'us_course' AND meta_value = '$us_course')"

);

解决方案

I would use this query:

SELECT

user_id

FROM

wp_usermeta

WHERE

(meta_key = 'first_name' AND meta_value = '$us_name') OR

(meta_key = 'yearofpassing' AND meta_value = '$us_yearselect') OR

(meta_key = 'u_city' AND meta_value = '$us_reg') OR

(meta_key = 'us_course' AND meta_value = '$us_course')

GROUP BY

user_id

HAVING

COUNT(DISTINCT meta_key)=4

this will select all user_id that meets all four conditions.