wordpress how to query wp_options table-Collection of common programming errors

I need to make an SQL call to find all records in wp_options matching a select statement. How do I query the table?

My script already has these resources called…

require_once('../../../wp-blog-header.php');
require_once('../../../wp-admin/includes/file.php');