mysql报错：Operand should contain 1 column(s)怎么修改呀

Question

mysql报错：Operand should contain 1 column(s)怎么修改呀

select  lj03.rid as rid FROM lj03
LEFT JOIN lj001 ON lj001.rid=lj03.rid
LEFT JOIN lj04 ON lj04.rid=lj03.rid 
LEFT JOIN hdsj ON hdsj.rid=lj03.rid 
# 加上关键词条件
where
lj04.she_qu like '%沸腾节%'
and
lj04.she_qu like '%潮划算%'
and
lj04.she_qu like '%安妮Anne%'
and
# 加上女性这个条件
lj03.rid in (
    select * from lj03
where lj001.sex like '%女' 
or lj001.sex like '%小雌兔' 
or lj001.sex like '%女士' 
or lj001.sex like '%female' 
or lj001.sex like '%0'
);

最后后面的in那里报错

Answer 1

完整修改如下：

select  lj03.rid as rid FROM lj03
LEFT JOIN lj001 ON lj001.rid=lj03.rid
LEFT JOIN lj04 ON lj04.rid=lj03.rid 
LEFT JOIN hdsj ON hdsj.rid=lj03.rid 
# 加上关键词条件
where
lj04.she_qu like '%沸腾节%'
and
lj04.she_qu like '%潮划算%'
and
lj04.she_qu like '%安妮Anne%'
and
# 加上女性这个条件
lj03.rid in (
    select lj001.rid from lj001
where lj001.sex like '%女' 
or lj001.sex like '%小雌兔' 
or lj001.sex like '%女士' 
or lj001.sex like '%female' 
or lj001.sex like '%0'
);