带有OR和Brackets的MySQL SELECT查询不起作用

Question

Hi I have a MySQL Select query as follow.

SELECT * 
FROM request
WHERE user_id=$user_id 
   OR vendor=$user_id
   OR (status='' AND services IN ( $service_arr )) 
ORDER BY id DESC

But this query is not working as expected. My OR condition is neglected and this query is getting data only when conditions under brackets are true. Meaning its getting only those rows where column name services has one of the items present in $service_arr.

Thanks

Answer 1

This example most probably help you

SELECT customer_id,first_name, last_name 
FROM customers 
WHERE (last_name = 'atiq')
   OR (last_name = 'hamza' AND state = 'attock')
   OR (last_name = 'usman' AND status = 'Active' AND state = 'islamabad');