order by rand() 就是随机排序 order by rand() limit 1 就是随机获取一行数据.满足2个条件,第一是 `Sex`='男' 和`Ctiy`='广州'select * from `user` where`Sex`='男' AND `Ctiy`='广州' order by rand() limit 1 ...
如何从mysql表中随机取一条符合条件的数据
order by rand() 就是随机排序
order by rand() limit 1 就是随机获取一行数据.
满足2个条件,第一是 `Sex`='男' 和`Ctiy`='广州'
select * from `user` where`Sex`='男' AND `Ctiy`='广州' order by rand() limit 12016-11-30
