带条件的查询
SELECT * FROM houseinfo where housetype='二手房'ORDER BY RAND() LIMIT 5
带不条件的查询
SELECT * FROM houseinfo ORDER BY RAND() LIMIT 5
带条件的查询
SELECT * FROM houseinfo where housetype='二手房'ORDER BY RAND() LIMIT 5
带不条件的查询
SELECT * FROM houseinfo ORDER BY RAND() LIMIT 5