1.查询
select * from `table` where `id`=1 and `name` in (2,3,4) and `age` in (select `age` from `table2` where ‘sex`=1) group by `id` desc limit 10
mysql常用命令
原文：http://www.cnblogs.com/rockking/p/7525262.html
