Mysql 不正确的数据获取类似查询

Question

我试图在此查询中从 user_id = 1 获取数据，但传入数据中有不同的 user_id 值。

select * 
from user_contacts uc 
inner join contacts_email_addresses ce on uc.id=ce.contact_id 
inner join contacts_phone_numbers cp on uc.id=cp.contact_id 
where uc.user_id=1 
   and cp.user_id=1 
   and ce.user_id=1 
   and uc.contact_name like '%test%' 
   or uc.contact_surname like '%test%' 
   or ce.email_address like '%test%' 
   or cp.phone_number like '%test%'

Answer 1

所有这些 AND 条件仅适用于第一个“或”条件(uc.contact_name like '%test%')。使用这样的括号:

select * 
from user_contacts uc 
inner join contacts_email_addresses ce 
  on uc.id=ce.contact_id 
inner join contacts_phone_numbers cp 
  on uc.id=cp.contact_id 
where uc.user_id=1 and 
      cp.user_id=1 and 
      ce.user_id=1 and 
     (uc.contact_name like '%test%' or 
      uc.contact_surname like '%test%' or 
      ce.email_address like '%test%' or 
      cp.phone_number like '%test%')