MySQL Subquery LIMIT

Posted by atif089 on Stack Overflow See other posts from Stack Overflow or by atif089
Published on 2010-05-18T10:39:10Z Indexed on 2010/05/18 10:40 UTC
Read the original article Hit count: 287

SELECT 
  comments.comment_id,
  comments.content_id,
  comments.user_id,
  comments.`comment`,
  comments.comment_time,
  NULL
FROM
  comments
WHERE
  (comments.content_id IN (SELECT content.content_id FROM content WHERE content.user_id = 1 LIMIT 0, 10))

© Stack Overflow or respective owner