Calling data from database using $wpdb.

Let’s say there is 21 names in the database under the table of Guest and column of Names.
How can I display all the names in the database and/or check to see if a name is already in the table.