//exists等同于if条件。如果符合条件(exists后的条件),则进行对数据库的操作
exists:
select * from label where exists (
select label_id from label_keyword lk where lk.LABEL_ID = 'ss2c9080ef0e9e241b010ea24285990235'
)
in:
//in后的括号里可以写一条sql语句,但必须要保证只能输出一个字段
select * from label_keyword where label_id in (
select id from label where label.label_title like '%免费%'
)