SQL help again and again ... smh and again

Yeah I don't think you should use count(*) or else everyone will be deleted; just use 1.

And there is not enough info to help OP.

 

Yep... that's a valid point. The exists statement works on the premise that if the subquery returns any results, the exists statement is considered true. If you try to select count(*) or any other aggregate in the subquery you will always return a result causing the exists statement to return true for all records.

 

Ya, that's why I said intention. I believe this is what he/she meant.

DELETE FROM clutchfans_users u
WHERE u.userid IN
(SELECT t.userid
FROM threads t
WHERE t.title LIKE '%SQL help%'
);

I bet the OP is wondering how the convo ended up here? hahaha

 

It's most likely due to the fact that the only context he provided was a .

 

<br>
Judging by his threads on the subject I'm not sure he knows what "here" is.

 

that would work too.. but that's slow. Exists is the way to go.

 

Well congratulations on what sounds like a good opportunity for you. If you aren't the SQL guy, wouldn't it make more sense to hit up your in-house DB folks? Either way, good luck man. Downtown is a cool place to work at...for a little while, haha. Your sig reminds me of Kanye's couple of lines in "This Way."

I don't know what's better, gettin laid or gettin paid.
I just know when I'm gettin one, the other's gettin away

@Coolweather: Good point. SQL optimization is obviously not my strong suit, heh.