In this recipe, we will learn how to search for information in a database table. Again, we assume that a users table comprising three columns, email_address, password, and address_of_delivery, already exists (please see the section, Creating a MySQL database and tables, of this chapter, where we created an ecommerce database and a users table in it). On entering an email address, the recipe will search the entire users database table for it, and if any row is found that matches the supplied email address, that user's password and address of delivery will be displayed on the screen.