<div>
try this <br />
DELETE FROM users &nbsp; WHERE uid IN (SELECT ur.uid FROM users_roles &nbsp;WHERE &nbsp;rid IN (7,5,6))
</div>


try this
DELETE FROM users   WHERE uid IN (SELECT ur.uid FROM users_roles  WHERE  rid IN (7,5,6))

<div>
How about<br />
<br />
DELETE FROM `users` WHERE `users.uid` IN (SELECT `uid` FROM `users_roles` WHERE `rid` = (7, 5, 6))<br />
<br />

</div>


How about

DELETE FROM `users` WHERE `users.uid` IN (SELECT `uid` FROM `users_roles` WHERE `rid` = (7, 5, 6))



<div>
I ended up deleting each rid:<br />
<br />
DELETE FROM drupal.users USING drupal.users INNER JOIN drupal.users_roles ON drupal.users.uid = drupal.users_roles.uid WHERE drupal.users_roles.rid = 7<br />
<br />
DELETE FROM drupal.users_roles WHERE drupal.users_roles.rid = 7<br />
<br />
Looks like both of the queries would combine this?
</div>


I ended up deleting each rid:

DELETE FROM drupal.users USING drupal.users INNER JOIN drupal.users_roles ON drupal.users.uid = drupal.users_roles.uid WHERE drupal.users_roles.rid = 7

DELETE FROM drupal.users_roles WHERE drupal.users_roles.rid = 7

Looks like both of the queries would combine this?

<div>
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
</div>


This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.

<div>
<div class="content wysiwyg-content">
Consider my limited experience with this, and here's the &quot;idea&quot; of what I want to do:<br />
<br />
DELETE FROM `users` INNER JOIN `users_roles` ON `users.uid` = `users_roles.uid` WHERE `users_roles.rid` (7, 5, 6);<br />
<br />
I don't think that's right, because I get a syntax error, and this is nothing I want to be unsure about, of course.<br />
<br />
* MySQL client version: 5.1.41<br />
* Drupal 6.19<br />
<br />
Thank you
</div>
</div>


Consider my limited experience with this, and here's the "idea" of what I want to do:

DELETE FROM `users` INNER JOIN `users_roles` ON `users.uid` = `users_roles.uid` WHERE `users_roles.rid` (7, 5, 6);

I don't think that's right, because I get a syntax error, and this is nothing I want to be unsure about, of course.

* MySQL client version: 5.1.41
* Drupal 6.19

Thank you

Drupal: DELETE users that match a certain role with MySQLAdmin

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.