MySQL开发技巧（三）3-2 [MySQL] 什么是同一属性的多值过滤

select a.user_name,b.skill,b.skill_level
from user1 a join user1_skills b on a.id =b.user_id
where skill in ('变化','念经') and skill_skill>0;

select a.user_name,b.skill,c.skill from user1 a join user1_skills b on a.id = b.user_id and b.skill='念经' join user1_skills c on c.user_id=b.user_id and
c.skill='变化' where b.skill_level>0 and c.skill_level>0;

select a.user_name,b.skill,b.skill,b.skill_level from user1 a join user1_skills
b on a.id =b.user_id;

// 如何查询出同时具有变化和念经这两项技能的取经人？

转载于:https://my.oschina.net/u/3430557/blog/1023584