select * from 天下3 wher 玩家='女' and 职业<>'龙巫' and 职业<>'鬼墨' and 性格 like '%欢乐豆%'
--------------------------------------------------------------------------------------
其实我真心找妹子,欢乐豆性格的妹子,不是指逗比~~~~(>_<)~~~~
select *
from 天下3
where 玩家 = '女'
and 性格 = 欢乐向
and 角色 = '女'
and instrb(玻璃心,'碎',1,1) = 0
and A='N'
and 婚否='N'
and 等级 <> '0'
and substr(门派,1,8) in ('冰心','天机','荒火','魍魉','羽毛','云麓','弈剑','太虚')
and 钻数<>'0'
order by 钻数