So I have this query.
SELECT * FROM `Comment` WHERE `Target` = '".$_GET['pp']."' AND `Id` NOT IN (SELECT `Target` FROM `Delete` WHERE `Type` = 'comment') ORDER BY `Id` DESC;
This selects comments which aren't deleted and displays them to members.
How could I modify it to select everything but with an additional boolean (called
I've heard about IF statements in SQL but don't know whether it's appropriate here or how it works.