How to retrieve user data based on role using SQL?

Add following in WHERE condition of your SQL query. 

WHERE t1.meta_key = "<?php echo $wpdb->prefix; ?>capabilities" 
AND ( t1.meta_value LIKE '%ROLE_YOU_WANT_TO_FILTER%')

Let me know if it works for you or not.

Related Posts:

  1. WordPress Database Huge wp_usermeta Table
  2. How to migrate a database from a server to another
  3. DB prefix not updating
  4. I wanted to Know that how can I give ingore to 0000-00-00 in my config file
  5. WordPress character set issue
  6. #1067 – Invalid default value for ‘post_date’ when trying to create a new column
  7. Deleting WordPress posts and media files based on author via MYSQL database
  8. Database table prefix different between wp-config.php and in database
  9. What is “Advanced” SQL?
  10. Oracle SQL query for Date format
  11. WPDB Insert or if exists Update
  12. Where are image paths to product category images stored in WordPress database
  13. Sharing database for collaborative development
  14. Display data from a non wordpress database on a page template
  15. Organizing WP Pages based on old website database
  16. Inserting Post Meta From SQL
  17. Bulk Update of Custom Post Type Post Status through SQL
  18. How do I add indexes to WordPress Database?
  19. Moving an entire wordpress site from one domain to a new domain and database
  20. Change SQL get_results to search for posts with custom term in custom taxonomy
  21. Would manually deleting the dumping data fix a “#1062 – Duplicate entry ‘1’ for key ‘PRIMARY'” phpMyAdmin error?
  22. Delete all post meta except featured image
  23. Block search SQL from happening
  24. wpdb query on custom table not working [closed]
  25. How to execute mulitple statement SQL queries using $wpdb->query?
  26. Delete duplicate rows from wordpress database where a column is duplicate in phpmyadmin
  27. Query WordPress database by registered date and role
  28. Using table lock with wp_insert_post?
  29. How to Move Local Singlesite Database to Remote Multsite Database?
  30. Scheduling posts in database
  31. Set Display Name to first and last name (phpmyadmin SQL Query)
  32. Size article thumbnails and retrieve them directly from database
  33. Emojis getting converted to “?”
  34. How to replace values in WordPress DB using phpMyAdmin
  35. How to query the WordPress database to get posts of a certain custom post type, taxonomy and field?
  36. Delete all post meta except featured image Using SQL
  37. wpdb_prepare with multiple or condition
  38. Accidentally deleted active_plugins portion of the wp_options DB table
  39. Uppercase to sentence case for post titles
  40. SQL Error wp_commentmeta – incorrect table definition
  41. phpMyAdmin displays error when importing database
  42. change wp user status from wp_users table
  43. WordPress and MySQL: how to transfer Meta_key and Meta_Value from one post_id to another
  44. How do I get the posts within a certain year/date(with sql query)?
  45. WordPress database import: Row size too large
  46. Export / import WordPress database
  47. WordPress is not creating table in database after activating plugin,
  48. Bulk-create posts from SQL database
  49. Difficulty importing my live site to local
  50. Create table from array with prepare
  51. Setup private content for specific users with daily updates [closed]
  52. Connection refused on locahost after importing database?
  53. is wordpress stores Role Id in WP database?
  54. Which data is written and stored in the database when read-only (non-posting, non-commenting) users visit the site?
  55. Insert Query not working in the form
  56. WPDB SQL query with prepare() returning variable, not db value
  57. Problems with moving my WordPress site to another domain/server
  58. Changing root password in PHPMyAdmin for WordPress Database when going live
  59. Can’t update WordFence Options, clear data manually
  60. Post Views / Hit Counter Problem?
  61. Why this query is not showing any result on wordpresss home page?
  62. Is it possible to have more than 1 MySQL database in my WordPress blog?
  63. pull data from a remote wordpress database
  64. Clear Terms from Taxonomy for Specific Post IDs?
  65. Is my way to change WordPress server is correct?
  66. Why does changing Database Table Prefixes result in loss of content?
  67. Options on how to Display member specific data from a MS SQL database
  68. Delete/Replace words from X to Y in post content
  69. SQL query to set posts in bulk based on the post content
  70. How to delete a particular row in a database table
  71. Delete all posts that do NOT have a specific tag
  72. Location of WP default mySQL tables creation file?
  73. SELECT SQL_CALC_FOUND_ROWS with wordpress search
  74. Files on Localhost, Database on Server
  75. Backing up WordPress database and files
  76. $wpdb->get_var – What value is returned when zero records are found?
  77. How to display data from db in select list [closed]
  78. wp_option table error while importing
  79. Installing local to live WP into subdirectory
  80. WordPress SQL – How to Check for Category?
  81. Getting value from database table depending on field value
  82. Delete user with only subscriber role
  83. custom tables in wordpress Database? (can i just create them with sql?)
  84. Can’t log into wordpress site – I have made a new user and still cant access
  85. Is there any way to monitor a MySQL db and check what has changed?
  86. Counting post and changing roles in mysql database. Query not code
  87. Accidently changed the GUID
  88. Deleting empty meta key values
  89. Sql query to get all metadata for a post
  90. I imported an restore an database and It shows #1067 – Invalid default value for ‘user_registered’
  91. Job and Employee Performance Tracking with Product Safety
  92. I need to find posts that contain YouTube links without http:// or https:// prefix and add http:// to all of them
  93. Is there any defects for using same database prefix in WordPress for multiple sites?
  94. Migrating meta_key and meta_value from old theme to new one
  95. SQL database import #1046 error
  96. What is recommended data type and encryption type for password in a database
  97. syntax error for changing user role from database
  98. How do I loop/iterate through posts to edit all img tags?
  99. Help posting values to DB on submit using $wpdb->query
  100. What’s the easiest way to connect external database and display data on wordpress?
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)