How To Search For Verified Members In The Database

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

Verified members can be identified directly within the website's database using the is_verified field.

Viewing the Verification Status

To see whether members have been verified, open Quick Edit for any Member:

Searching for Verified Members

To search for verified members directly in the database, go to:

Developer Hub → MySQL Database

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

Open the users table.

Click on SQL:

Paste the specified SQL code and click Go:

This is the SQL code needed to run: 

SELECT * FROM `users_data` WHERE verified > 0;

Which will display members that are verified on your site: