Displaying data on any element using a WHERE clause

Need help Database
1

Can’t we view information with a certain condition/restriction like in SQL?

example:

VIEW name
WHERE job_id = ‘IT Admin’;

This is to display people from the DB that work only as IT Admins.

2

This should be possible with filtered advanced option? I don’t know any way from the database except for typing in the search field.

You can also use a plugin that connects to the database.

3

Thank you for the response, I will try out your suggestions.