mySQL > Limit the same amount of value returned

Question

I am developing Content / Comment system.. I want: For each content in array to be returned maximum 10 comments.. I tryed LIMIT 20, but this is limiting the total results, how to limit only the repeated values in column comment_id

$contentidArray is array of content ID's

$sthandler = $conn->prepare("SELECT * FROM comments WHERE content_id in (".$contentidArray.") order by total_reactions desc");

$sthandler->execute();

So you want to add a `LIMIT 10`? – Jonnix Jun 05 '19 at 14:14 — Jonnix, Jun 05 '19 at 14:14
What is the problem are u facing? – Masivuye Cokile Jun 05 '19 at 14:15 — Masivuye Cokile, Jun 05 '19 at 14:15

score 0 · Answer 1 · answered Jun 05 '19 at 14:18

0

Check this query for self join to fetch max 10 records per content_id,

select c.* FROM comments c
left join comments c1 ON c.content_id = c1.content_id AND c.id <= c1.id
group by c.id
having COUNT(*) <= 10
order by c.content_id, c.id DESC;

answered Jun 05 '19 at 14:18

Rahul

17,231
7
35
54

Thanks i will try it now.. – Halid Kyazim Jun 05 '19 at 14:19

mySQL > Limit the same amount of value returned

1 Answers1