OK, so you want to get set complements from MySQL.
One way to do this will be with query like that:
SELECT u.ID
FROM
wp_users u
LEFT OUTER JOIN wp_comments c ON
(u.ID = c.user_id AND comment_post_ID = <YOUR_POST_ID>)
WHERE c.user_id is null
But you should remember, that such query won’t be very efficient. So it will be OK, if your DB isn’t very big. You should think of some other solution otherwise.
Related Posts:
- Commenting in user profile page?
- Show content only if member left a comment
- Post comment as different user than logged in
- Get most active users sort by comment count
- WordPress comments email notification for authors
- List User Comments on User Profile BuddyPress [closed]
- Hold comments for moderation only if user is not logged in
- Display WordPress commenter nice name
- Check if someone recently commented in one of my posts
- Highlighting the current users comment
- Display the number of unseen comments on a page since the user last visit
- Allow the comment author to delete their own comments
- All users/comments suspected as bot? [closed]
- Commenting in user profile page?
- if user role is then echo text
- Remove the deleted user comment
- Anonymize comments after one year
- How can I get list of emails of users who commented on a post?
- Best way to tell if a comment is from a user?
- Custom comment field not showing when logged-in
- get_comment_author_link not working properly
- Problem in getting user comments permalinks
- I want to limit registered user to 1 comment per post in WordPress
- Let user delete comment on front end only
- selectively disable akismet
- How to display comments by logged in user and responses?
- Deleting users do not deletes coments
- delete user not working
- R: Comment out block of code
- How to rearrange fields in comment_form()
- How do I delete all comments from a specific old blog post?
- Removing the “Website” Field from Comments and Replies?
- How to load and show comments with AJAX instead of pagination?
- Comments not appearing at all
- Hook/Filter before and after comments
- Comment form validation
- I have tried using Plugins to remove 72K comments with no success
- Display commenter’s registration date on comments?
- show un-approved comments at wordpress front end
- How to add consent checkbox in comment section
- How to add pagination to comments?
- WP 4.4.1 allow empty comments via add_action ‘pre_comment_on_post’
- How to get replies of a comment?
- Share comment to twitter after publishing [closed]
- changing comment-page-# to something like review-page-#
- show if comment is in moderation
- Disable or Enable Comments on Front end [closed]
- Deleting the attached “comment replies” when trashing a comment
- How can I get a list of comments by target
- Load comments.php template outside the post loop
- Auto-fill Custom comment fields
- How to make all the posts commentable by default? Imputs in Settings/Discussions are not saved
- How to auto empty comment trash after X days
- comments.php keep comment date/time but remove date/time’s #hyperlink
- Control panel loads slowly due to 2 slow queries on comment table
- Display complete comment section via post ID
- User capability for editing their own comments
- Comment Pagination Behavior wp_list_comments() – comment ordering and pagination
- Check if comment was successfully submited
- After Submitting Comment Form Shows an Empy Page in WordPress
- Unique User for all visitor, but possibility to comment with unique name
- comments_array filter doesn’t work in some themes
- Redirect when click on “response” in comment section
- Link to a User’s Forum Profile From Their Comment
- strange behavior with comment position
- Safely editing core files
- Way to count the number of people who have commented on a post?
- Batch approve comments
- Disable comments and pingbacks on old custom post types
- Add paragraph tags to comments
- How to tweak comment fields properly from functions.php
- How to allow duplicate comments?
- Two textareas showing up in comments.php
- WordPress comments – delimiter “/” not found
- Give subscribers the option to post anonymously
- Styling Admin comments in WP 3.1.3
- Displaying comment counts in WP Gallery thumbnail view
- Removing comment option
- pre_comment_content filter not working using IntenseDebate Enhanced moderation
- Edit Comments Fields
- Random output of comments using a shortcode
- Allow comments only for custom post type
- Comment author profile image
- Comment Form Fields when user logged in
-   not working in comments
- Comments.php is not getting called on main blog page
- Allowing comments on author pages
- Comment section not appearing on posts
- How can I see whether a commenter has subscribed to be notified of replies / other comments to a post
- Where is the Leave a Comment link set
- Disable comment moderation in multisite
- URLs to user page is broken
- Comments Template shows, but not the comments
- Auto disable comments with custom field
- I want to fill the comment with the comment count?
- Force logged in users to provide more data when commenting
- How to remove or customize “Comment” in comments form?
- Getting thousands of spam comments
- check if a comment was made by a registered user
- WordPress Editor widgets “comments” and “post comments form” getting disappeared with elementor [closed]