Article suggestions
  1. Home
  2. Section: Developer Hub
  3. How To Search For Featured Members In The Database

How To Search For Featured Members In The Database

How To Search For Featured Members In The Database
  • avatar
Written by Chan Nier
Updated on February 19, 2025

 Link: https://support.brilliantdirectories.com/support/solutions/articles/12000059855

To see the list of members who have been featured on the homepage via its Quick Edits:

Navigate to Developers --> MySQL Database:

Click on the database that ends with wording "directory":

Conduct a search for the table users_data and open it by clicking on it:

Click on SQL:

Paste the specified SQL code and click Go:

This is the SQL code needed to run:

SELECT * FROM `users_data` WHERE featured > 0;
SQL

Which will display members that are featured on your site:


Thank you for leaving a rating!
Did you find this article helpful?
0 out of 0 people found this article helpful so far
Can't find what you're looking for? Get in touch
How can we help?
Send your question below and we'll get back to you as soon as possible.
Cancel
translation missing: en.kb.default.contact_form_error
×
Thanks for your message!
Thanks for your message!
×