php mysql类 查询中 另一个查询,php – Mysql如何从同一个表中的单个查询中获取2组结果？...

我有这样的

mysql评论表.

+------------+------------------+------+-----+---------+----------------+

| Field | Type | Null | Key | Default | Extra |

+------------+------------------+------+-----+---------+----------------+

| userid | int(11) | NO | | 0 | |

| comment | char(255) | NO | | NULL | |

| content | int(11) | NO | MUL | 0 | |

| ratings | int(11) | NO | | 0 | |

| datetime | datetime | NO | | NULL | |

| ip | int(10) unsigned | NO | | NULL | |

| is_updated | tinyint(2) | NO | | 0 | |

| record_num | int(11) | NO | PRI | NULL | auto_increment |

+------------+------------------+------+-----+---------+----------------+

现在我可以使用像这样的INNER JOIN查询从另一个表中获取来自此用户名和用户名的注释.

我可以获得前3条评论ORDER BY comments.ratings DESC

SELECT comments.userid, users.username, comments.comment, comments.ratings, comments.datetime, comments.record_num , content.uploader , content.anonymous

FROM comments

LEFT JOIN users ON comments.userid = users.record_num

LEFT JOIN content ON comments.content = content.record_num

WHERE comments.content = ? ORDER BY comments.ratings DESC limit 3

和

获得定期评论ORDER BY comments.datetime DESC.

SELECT comments.userid, users.username, comments.comment, comments.ratings, comments.datetime, comments.record_num , content.uploader , content.anonymous

FROM comments

LEFT JOIN users ON comments.userid = users.record_num

LEFT JOIN content ON comments.content = content.record_num

WHERE comments.content = ? ORDER BY comments.datetime DESC limit ?, ?

我正在尝试做的是首先通过评级向用户显示前3条评论,然后通过comments.datetime DESC定期评论.

现在我怎么能将上面两个mysql查询加入到一个？