Re: Delete and select in the same query

[Peter Brawley]

What's your objection to posting the result of ...

Show Create Table comments;

?!?

Well, whatever it is, we don't have the info, so I'll suppose that the table has a primary key column named ID: then the IDs of user N's comments and replies to them are ...

select ID from comments where user_id=N;
union
select ID from comments a
join comments b on a.id_parent=b.id_comment
where b.user_id=N;