mysql - 匹配来自多个表的数据

Question

我有 4 个表，:

login 列 userid, name, pass, email
phyinfo 包含列用户 ID、高度、肤色、种族、性别、体型
loc 包含 userid、country、state、city 列
和
skills 包含 userid 列，skillslists 具有技能值索引(逗号分隔)

现在我想按所有人搜索用户(例如:height=5'21"+ gender=male + country=india + skills=design)

我不知道如何进行混合查询，它将返回符合条件的用户 ID。请帮忙

这是我到目前为止尝试过的查询:

SELECT userid 
 FROM phyinfo 
 WHERE height='5\'21"' AND gender='male' 
 UNION 
  SELECT userid 
  FROM loc 
  WHERE country='india' 
  UNION 
   SELECT userid 
   FROM skills 
   WHERE FIND_IN_SET(8 , skillslists) 

Answer 1

试试这个:

SELECT L.userid,L.name,L.pass,L.email
FROM login L INNER JOIN
   phyinfo P on L.userid=P.userid INNER JOIN
   loc on L.userid=loc.userid INNER JOIN
   skills S on S.userid=L.userid
WHERE P.height='5''21"' AND P.gender='male' AND loc.country='india' AND S.skillslists LIKE '%design%'