Remove user which has customer user role from database SQL code

deleteCustomers.sql

DELETE u, um
FROM wp_users u
LEFT JOIN wp_usermeta um ON um.user_id = u.ID
WHERE u.ID IN (
    SELECT user_id
    FROM (
        SELECT user_id
        FROM wp_usermeta
        WHERE meta_key = 'wp_capabilities'
          AND meta_value LIKE '%customer%'
    ) AS customer_users
);

🛠️ Notes:
This query:
- Deletes from wp_users and wp_usermeta.
- Targets users who have a meta_key of wp_capabilities with customer in the role.
- If your table prefix is not wp_, replace it throughout the query.